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

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

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


.

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


.

.