Copying protected worksheet

  • Thread starter Thread starter Mona
  • Start date Start date
M

Mona

Is there a way to copy a protected worksheet to another
worksheet and keep the protection intact?
 
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
 
-----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


---
Message posted

.
The only options on the sheet tab are select are Select
Click to expand...
all Sheets and View
Code. The sheet is Sheet protected and Windows protected.
 
Back
Top