Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Stilla
 
Posts: n/a
Default protection de-activating tab-naming code

I got help on a Macro for automatically naming tabs from a cell on a
worksheet. Works great. BUT, protecting a workbook completely deactivates
it.

Any ideas?

Thanks in advance.

Stilla
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
SYBS
 
Posts: n/a
Default protection de-activating tab-naming code

I think (as I am just busy going through the same thing), the best way seems
to be preceed the macro with ActiveSheet.Unprotect (password if one) and end
the macro with ActiveSheet.Protect (password if one)

This does enable the macros to work, but I have had a few problems making it
work consistently with up to 60 macros on a page !! Hope youre luckier.

Sybs


"Stilla" wrote:

I got help on a Macro for automatically naming tabs from a cell on a
worksheet. Works great. BUT, protecting a workbook completely deactivates
it.

Any ideas?

Thanks in advance.

Stilla

  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
SYBS
 
Posts: n/a
Default protection de-activating tab-naming code

Forgot to mention (cos I just found out), mine worked fine when I did the
activate thing but I had to then go back and put the password in brackets and
quotes. If yours still isn't working try that. Hope it helps.

Sybs

"SYBS" wrote:

I think (as I am just busy going through the same thing), the best way seems
to be preceed the macro with ActiveSheet.Unprotect (password if one) and end
the macro with ActiveSheet.Protect (password if one)

This does enable the macros to work, but I have had a few problems making it
work consistently with up to 60 macros on a page !! Hope youre luckier.

Sybs


"Stilla" wrote:

I got help on a Macro for automatically naming tabs from a cell on a
worksheet. Works great. BUT, protecting a workbook completely deactivates
it.

Any ideas?

Thanks in advance.

Stilla

Reply
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
Can someone help me put psuedo code into actual excel macro?? bxc2739 Excel Discussion (Misc queries) 1 April 22nd 06 02:58 PM
VBA code error with Protection turned on - help please Fred Excel Discussion (Misc queries) 1 March 17th 06 04:06 PM
Help, need to speed up this macro retseort Excel Discussion (Misc queries) 3 January 12th 06 12:33 PM
Complicated If Then / V Lookup / Match Statement... ryesworld Excel Worksheet Functions 17 December 10th 05 02:09 PM
Need 2 add second then third code with first code in the Tab View nick s Excel Worksheet Functions 3 December 6th 05 02:20 AM


All times are GMT +1. The time now is 05:08 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"