View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
David David is offline
external usenet poster
 
Posts: 1,560
Default Rename Protected Worksheets

I want to allow users to rename worksheets, but do nothing else to them.
I have programmed VBA with the "real" sheet number so that my code
referencing the sheets will not be affected.
The code protects the workbook with structure = true. Is there any way to
let users just change the names (they want to put technician names on the
sheets instead of a number assigned to each sheet). Thanks!