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?
 

Some videos you may like

Excel Facts

Whats the difference between CONCAT and CONCATENATE?
The newer CONCAT function can reference a range of cells. =CONCATENATE(A1,A2,A3,A4,A5) becomes =CONCAT(A1:A5)

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.
 

Watch MrExcel Video

Forum statistics

Threads
1,122,662
Messages
5,597,440
Members
414,143
Latest member
CDLAegis

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