Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBAProject Protect
The following code is present in a subroutine in a
standard module. Sheets("NEXTRECORD").Visible = xlVeryHidden No problem as long as the VBAProject is not protected. What code would I use to protect and unprotect the VBAProject? Thanks in advance. Kevin |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBAProject Protect
Hiding a sheet shouldn't be affected by project protection. It would be
affected if the workbook structure is protected. -- Regards, Tom Ogilvy "Kevin" wrote in message ... The following code is present in a subroutine in a standard module. Sheets("NEXTRECORD").Visible = xlVeryHidden No problem as long as the VBAProject is not protected. What code would I use to protect and unprotect the VBAProject? Thanks in advance. Kevin |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBAProject Protect
Thanks Tom.
Yes, the Workbook is protected. The VBA code also includes, Workbooks(WorkbookName).Protect Password:=DwgNumLogPwd where WorkbookName is set to, WorkbookName = Sheets("INPUTDATA").Range _ ("strFileName").Value in a separate module. Mea culpa. Kevin -----Original Message----- Hiding a sheet shouldn't be affected by project protection. It would be affected if the workbook structure is protected. -- Regards, Tom Ogilvy "Kevin" wrote in message ... The following code is present in a subroutine in a standard module. Sheets("NEXTRECORD").Visible = xlVeryHidden No problem as long as the VBAProject is not protected. What code would I use to protect and unprotect the VBAProject? Thanks in advance. Kevin . |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBAProject Protect
Problem resolved.
I realize I don't need to protect/unprotect the VBAProject. A simple, Workbooks(Name).UnProtect Password:=DwgNumLogPwd <code Workbooks(Name).Protect Password:=DwgNumLogPwd works. Kevin -----Original Message----- Thanks Tom. Yes, the Workbook is protected. The VBA code also includes, Workbooks(WorkbookName).Protect Password:=DwgNumLogPwd where WorkbookName is set to, WorkbookName = Sheets("INPUTDATA").Range _ ("strFileName").Value in a separate module. Mea culpa. Kevin -----Original Message----- Hiding a sheet shouldn't be affected by project protection. It would be affected if the workbook structure is protected. -- Regards, Tom Ogilvy "Kevin" wrote in message ... The following code is present in a subroutine in a standard module. Sheets("NEXTRECORD").Visible = xlVeryHidden No problem as long as the VBAProject is not protected. What code would I use to protect and unprotect the VBAProject? Thanks in advance. Kevin . . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cracking VBAProject Password | Excel Discussion (Misc queries) | |||
How with VBA, can I activate one of many modules in a VBAProject? | Excel Discussion (Misc queries) | |||
VBAProject | Excel Worksheet Functions | |||
code in VBAProject will not run | Excel Programming | |||
How to Delete a VBAProject | Excel Programming |