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
.
.
|