Hi folks:

I can't seem to find the code to make a specific worksheet READ ONLY in
a workbook. I'm trying to stay away from making the entire workbook
read only and trying to stay away fom protecting the sheet 'cause once
the wb is saved under a different name, the ws password is gone.

Any help is welcome,


---
Message posted from http://www.ExcelForum.com/

There is no readonly property that can be applied to a single sheet in the
workbook.

--
Regards,
Tom Ogilvy

"halem2 " wrote in message
...
Hi folks:

I can't seem to find the code to make a specific worksheet READ ONLY in
a workbook. I'm trying to stay away from making the entire workbook
read only and trying to stay away fom protecting the sheet 'cause once
the wb is saved under a different name, the ws password is gone.

Any help is welcome,


---
Message posted from http://www.ExcelForum.com/