RE: Is it possible to hide and show buttons?

Tech-Archive recommends: Fix windows errors by optimizing your registry

Commandbutton1 was the name of my button and was used as an example.

You would use the names of your buttons.

--
Regards,
Tom Ogilvy


"Kiba" wrote:

Neither way seems to be working I just get the debug message. Do I need to
change the Commandbutton1 to something else?

"Tom Ogilvy" wrote:

You can't find it because it is inherited from the container - the Ole Object
(assuming these are on a work***).

so from the immediate window as a demo:

? Active***.Commandbutton1.Visible
True
active***.Commandbutton1.Visible = False

? Active***.Commandbutton1.Visible
False

Or you can do

Active***.OleObjects("Commandbutton1").Visible = False

Again, from the immediate window as a demo:
Active***.OleObjects("Commandbutton1").Visible = True
? Active***.Commandbutton1.Visible
True

--
Regards,
Tom Ogilvy


"Kiba" wrote:

I can't find a visible property How would I go about finding it and changing
it with a code?

"Tom Ogilvy" wrote:

The buttons have a visible property. You would need to run code to set that
property to false. So, the the update click event would contain code to make
the Undo Update visible as an example.

The work***/workbook have other events that could come into play.
--
Regards,
Tom Ogilvy



"Kiba" wrote:

I have four buttons on my spread***. (Top of Page, Update, Undo Update,
Redo Update). I was wondering if there was a way to hide the Undo Update
when the spread *** is opened until the update button is pressed. And hide
the Redo Button untill the Undo button is pressed.)
.

Quantcast