Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi
I have code that deletes the active worksheet that the user is viewing. I have four worksheets within the workbook that I do not want the user to be able to delete. I would like to have the code check and make sure the user in not currently on any of those 4 worksheets and if they are not...then have the code run to delete the active worksheet.. if they are on any one of those 4 sheets...then a message would pop up stating " cannot delete active worksheet......" I'm sure how to do this properly. Any help would be greatly appreciated. Thanks in advance. Kimberly |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do you view an active macro code? | Excel Discussion (Misc queries) | |||
Need VBA Code to Let User Define Active Sheet | Excel Discussion (Misc queries) | |||
What is the code for the active worksheet? | Excel Discussion (Misc queries) | |||
How to Add Rows From Active Cell with in a XLL Code | Excel Worksheet Functions | |||
Code to print most (not all) pages within active workbook | Excel Programming |