| Home |
| Search |
| Today's Posts |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Required Selection to save or print
I got it working...but now every spreadsheet I open has the Save/Save/Print
button disabled. I put the "Private Sub Workbook_WindowActivate(ByVal Wn As Window)" in the "This Workbook" item under Excel Objects...the EnableControls in a module in that workbook only and assigned the _Click subs to the radio buttons. "Greg Glynn" wrote: The 2 SUBs (WorkBook_WindowActivate and Workbook_WindowDeactivate) get added to the WORKBOOK module The three _CLICK SUBs are associated with your Radio Buttons The EnableControls SUB you can create as a module. Greg |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Time required to 'save as' a large file | Excel Worksheet Functions | |||
| Required selection | Excel Worksheet Functions | |||
| How can I print frozen panes to appear above print selection in Ex | Excel Discussion (Misc queries) | |||
| Time Required to Save a File | Excel Discussion (Misc queries) | |||
| Save, Save As, Print Grayed Out when instance created via VBA/VB6 | Excel Programming | |||
Threaded Mode
