Can not move sheet to Shared Workbook. How can solve ?

sthanawa

Board Regular
Joined
Jul 5, 2006
Messages
80
Hi All,
I have 2 workbooks.

1. Workbook name OldDataBase.xls
2. Workbook name Result DataBase.xls (This workbook is share workbook)

OldDatabase.xls contain a short Macro as following.

Sub AddNewDatabase()

Sheets("DataBase 2005").Select
Sheets("DataBase 2005").Copy After:=Workbooks( _
"Result DataBase.xls").Sheets(1)
End Sub

The propose is to move sheet Database 2005 from OldDataBase.xls to Result Database.xls

But I found run time error '1004' said
'This command is not available in a shared workbook'

Please suggest me , how can I solve this problem ?
 

Excel Facts

What is the last column in Excel?
Excel columns run from A to Z, AA to AZ, AAA to XFD. The last column is XFD.

agihcam

Well-known Member
Joined
Jan 16, 2006
Messages
1,624
how about unsharing the workbook, copy the sheets then shared again?
 

sthanawa

Board Regular
Joined
Jul 5, 2006
Messages
80
Hi All,

My probelm is that the Workbook name 'Result DataBase.xls ' was set to be shared workbook.

When I move a sheet from workbook 'OldDataBase.xls' into 'Result Database.xls' by VBA , it alert me with run time error '1004' said
'This command is not available in a shared workbook'

I can not disable shared workbook for 'Result Database.xls' because this workbook was openned by other user at the same time.

But I want to update this workbook by add a new sheet by move that sheet from 'OldDataBase.xls'

How can I solve this problem ?
 

Forum statistics

Threads
1,141,755
Messages
5,708,320
Members
421,565
Latest member
Lastadiego

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