Might be Spy Hard (1996).
Secret agent WD-40 Dick Steele (Leslie Nielsen) has his work cut out
for him. Along with the mysterious and lovely Veronique Ukrinsky,
Agent 3.14, he must rescue the kidnapped Barbara Dahl and stop the
evil genius, a General named Rancor (Andy Griffith), from seizing
control of the entire world.
Rancor was wounded in an earlier encounter and no longer has arms.
However, he can "arm" himself by attaching robotic limbs with various
weapons attached. Steele is talked out of retirement by an old friend,
agent Steven Bishop (Robert Guillaume), and given his new assignment
by The Director (Charles Durning), who also is testing out a variety
of elaborate disguises. At headquarters, Steele encounters an old
agency nemesis, Norm Coleman (Barry Bostwick), and flirts with the
Director's adoring secretary, referred to as Miss Cheevus (Marcia Gay
Harden).
On the job, Steele is assisted by an agent named Kabul (John Ales),
who gives him rides in a never-ending variety of specially designed
cars. They seek help from McLuckey (Mason Gamble), a blond child, home
alone, who is very good at fending off intruders. Steele resists the
temptations of a dangerous woman (Alexandra Paul) he finds waiting for
him in bed. But he does work very closely with Agent 3.14 (Nicollette
Sheridan), whose father, Professor Ukrinsky (Elya Baskin), is also
being held captive by Rancor.
Everything comes to an explosive conclusion at the General's remote
fortress, where Steele rescues both Barbara Dahl (Stephanie Romanov)
and Miss Cheevus and launches a literally disarmed Rancor into outer
space, saving mankind.
Clip of the chair scene:
From CrankyCritic.com:
In some ways Spy Hard is a twisted inside out and played on its side
version of Buck Henry and Mel Brooks' Get Smart television series.
This time though, Agents 86 and 99 are nowhere to be seen. Agent 22 is
now the Director (played by Charles Durning) and he has moved up in
the world, impersonating furniture, rugs, Venetian blinds and other
large household items. Borrow the undersexed secretary and secret
weapons designer from the James Bond movies, stir it all up and see
how many jokes about flatulence you can come up with.