Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Disable Close Button
I wanted to disable the close button in the upper right hand corner of Excel
so users would have to use a button on the spreadsheet (assigned to a macro) to close the worksheet. I used the following code: Private Sub WorkBook_BeforeClose (Cancel As Boolean) Cancel = True End Sub The code works great but now my macro button will not work and I can't close the worksheet at all. Can you help me out? I'd appreciate it! -- Dan N |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Use the Merge & Center Button with unprotected Cells - sheet prote | Setting up and Configuration of Excel | |||
Disable Exit button on a UserForm | Excel Discussion (Misc queries) | |||
Disable "save" option on close. | Excel Discussion (Misc queries) | |||
Userform + close button | Excel Discussion (Misc queries) | |||
VBA: Disable Frame and Radio Buttons based on Another Radio Button Being True | Excel Worksheet Functions |