Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Can someone help me put psuedo code into actual excel macro?? | Excel Discussion (Misc queries) | |||
VBA code error with Protection turned on - help please | Excel Discussion (Misc queries) | |||
Help, need to speed up this macro | Excel Discussion (Misc queries) | |||
Complicated If Then / V Lookup / Match Statement... | Excel Worksheet Functions | |||
Need 2 add second then third code with first code in the Tab View | Excel Worksheet Functions |