LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 87
Default Donot allow user to change name of the worksheet

Hi

I have a workbook with several sheets in it. However I donot want anyone to
change name of one worksheet named 'Data'. He can rename other sheets. Is it
possible to prevent user from changing name of one sheet?

(This is because my macro will delete all sheets except the one with name
'Data'. If user changes name of 'Data' sheet, tehn macro will delete it!)

Thank You
Pawan


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Change of cell format if overwritten by User GrahamB Excel Worksheet Functions 1 February 23rd 07 09:21 PM
Can I change the user name that is registered? Breyno Excel Discussion (Misc queries) 4 July 18th 06 10:51 PM
prompt user to change source of links Bobak Excel Discussion (Misc queries) 4 March 20th 06 07:29 PM
Wait for user to change data after msgbox ???? CanadianTrev Excel Discussion (Misc queries) 1 June 18th 05 08:27 PM
how would i change default user name all excel files learner Excel Discussion (Misc queries) 1 November 29th 04 10:12 PM


All times are GMT +1. The time now is 06:16 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"