New to me...

Wil Moosa

Well-known Member
Joined
Aug 11, 2002
Messages
882
On the server we used a workbook which was shared. I need to make some changes in the workbook and therefor I "unshared" the workbook.

Unfortunately I am not able anymore to copy and rename a single sheet. What is it I am doing wrong?
 

Excel Facts

What is =ROMAN(40) in Excel?
The Roman numeral for 40 is XL. Bill "MrExcel" Jelen's 40th book was called MrExcel XL.

Wil Moosa

Well-known Member
Joined
Aug 11, 2002
Messages
882
The workbook as a whole never has been protected. The individual sheets are... but were unprotected before copying the individual sheet. The whole proces happens without error message but no copied sheet shows up.
 

Wil Moosa

Well-known Member
Joined
Aug 11, 2002
Messages
882
Also related to the shared workbook....

I have a sheet protected and a macro to sort the data on the sheet. The macro starts and finishes with unprotecting and protecting the sheet. Does unprotect not work in an shared environment? I do get an error 1004 referring to the protection of the sheet. In not shared mode it works fine.
 

Wil Moosa

Well-known Member
Joined
Aug 11, 2002
Messages
882
The first problem seems to be solved as it was a server problem.

The second problem can not be solved by switching of the macro as the macro is triggered by activating the sheet (sheet code). By rearranging the code I was able to by pass the problem. Thanks.
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,168,079
Messages
5,857,228
Members
431,864
Latest member
Raul Ruan

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top