Copying protected worksheet

[Mona]

Is there a way to copy a protected worksheet to another
worksheet and keep the protection intact?

 

[gilbert]

Yeap....just use the normal sheet copy function.

1. Right click on the protected sheet tab at the bottom
2. Choose move or copy (check the make a copy box),
3. Defined where would you like to copy the worksheet to
4. Click 'OK' and done

Alternatively, consider copy to another file using normal Windo
command of create copy of the file.

HTH.

Rgds,
Gilber

 

[Mona]

-----Original Message-----
Yeap....just use the normal sheet copy function.

1. Right click on the protected sheet tab at the bottom
2. Choose move or copy (check the make a copy box),
3. Defined where would you like to copy the worksheet to
4. Click 'OK' and done

Alternatively, consider copy to another file using normal Window
command of create copy of the file.

HTH.

Rgds,
Gilbert


---


.
The only options on the sheet tab are select are Select

all Sheets and View
Code. The sheet is Sheet protected and Windows protected.