| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Is it possible to hide and show buttons?
I have four buttons on my spreadsheet. (Top of Page, Update, Undo Update,
Redo Update). I was wondering if there was a way to hide the Undo Update when the spread sheet is opened until the update button is pressed. And hide the Redo Button untill the Undo button is pressed.) |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Is it possible to hide and show buttons?
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 worksheet/workbook have other events that could come into play. -- Regards, Tom Ogilvy "Kiba" wrote: I have four buttons on my spreadsheet. (Top of Page, Update, Undo Update, Redo Update). I was wondering if there was a way to hide the Undo Update when the spread sheet is opened until the update button is pressed. And hide the Redo Button untill the Undo button is pressed.) |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Is it possible to hide and show buttons?
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 worksheet/workbook have other events that could come into play. -- Regards, Tom Ogilvy "Kiba" wrote: I have four buttons on my spreadsheet. (Top of Page, Update, Undo Update, Redo Update). I was wondering if there was a way to hide the Undo Update when the spread sheet is opened until the update button is pressed. And hide the Redo Button untill the Undo button is pressed.) |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Is it possible to hide and show buttons?
You can't find it because it is inherited from the container - the Ole Object
(assuming these are on a worksheet). so from the immediate window as a demo: ? Activesheet.Commandbutton1.Visible True activesheet.Commandbutton1.Visible = False ? Activesheet.Commandbutton1.Visible False Or you can do Activesheet.OleObjects("Commandbutton1").Visible = False Again, from the immediate window as a demo: Activesheet.OleObjects("Commandbutton1").Visible = True ? Activesheet.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 worksheet/workbook have other events that could come into play. -- Regards, Tom Ogilvy "Kiba" wrote: I have four buttons on my spreadsheet. (Top of Page, Update, Undo Update, Redo Update). I was wondering if there was a way to hide the Undo Update when the spread sheet is opened until the update button is pressed. And hide the Redo Button untill the Undo button is pressed.) |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Is it possible to hide and show buttons?
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 worksheet). so from the immediate window as a demo: ? Activesheet.Commandbutton1.Visible True activesheet.Commandbutton1.Visible = False ? Activesheet.Commandbutton1.Visible False Or you can do Activesheet.OleObjects("Commandbutton1").Visible = False Again, from the immediate window as a demo: Activesheet.OleObjects("Commandbutton1").Visible = True ? Activesheet.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 worksheet/workbook have other events that could come into play. -- Regards, Tom Ogilvy "Kiba" wrote: I have four buttons on my spreadsheet. (Top of Page, Update, Undo Update, Redo Update). I was wondering if there was a way to hide the Undo Update when the spread sheet is opened until the update button is pressed. And hide the Redo Button untill the Undo button is pressed.) |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Is it possible to hide and show buttons?
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 worksheet). so from the immediate window as a demo: ? Activesheet.Commandbutton1.Visible True activesheet.Commandbutton1.Visible = False ? Activesheet.Commandbutton1.Visible False Or you can do Activesheet.OleObjects("Commandbutton1").Visible = False Again, from the immediate window as a demo: Activesheet.OleObjects("Commandbutton1").Visible = True ? Activesheet.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 worksheet/workbook have other events that could come into play. -- Regards, Tom Ogilvy "Kiba" wrote: I have four buttons on my spreadsheet. (Top of Page, Update, Undo Update, Redo Update). I was wondering if there was a way to hide the Undo Update when the spread sheet is opened until the update button is pressed. And hide the Redo Button untill the Undo button is pressed.) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Hide buttons | Excel Discussion (Misc queries) | |||
| Hide option buttons | Excel Discussion (Misc queries) | |||
| Hide Show Command Buttons | Excel Programming | |||
| pivot chart is it possible to hide individual field buttons? Layout Field buttons | Charts and Charting in Excel | |||
| How do I hide tab scrolling buttons? | Excel Discussion (Misc queries) | |||
Hybrid Mode
