View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
KimberlyC KimberlyC is offline
external usenet poster
 
Posts: 124
Default Code to check for active worksheet

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