View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Kevin Kevin is offline
external usenet poster
 
Posts: 134
Default 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



.

.