Hiding the personal workbook

[Mary C]

I am having trouble hiding the personal workbook so I can open 2 or more
sessions of excel without getting the error that workbook is locked for
editing. I wrote a macro last week and can't get rid of the error.

 

[jlclyde]

I am having trouble hiding the personal workbook so I can open 2 or more
sessions of excel without getting the error that workbook is locked for
editing.  I wrote a macro last week and can't get rid of the error.

While your Personnel Macro book is active. Click on Window/ Hide.
Close Excel. It will ask you to save changes to Pers. workbook. Say
yes. Now reopen Excel. It shoudl open up to Book1 or whatever you
ahve your default set to.

I hope this helps,
Jay

 

[Mary C]

I have opened the person workbook and it is hidden so where do I go from here?

 

[jlclyde]

I have opened the person workbook and it is hidden so where do I go from here?
--
Mary C







- Show quoted text -

If it is already hidden then you can still do what you need to do in
excel. The other sheet will just say read only. You can still open
multiple workbooks this way.

Jay

 

[Mary C]

Thanks for the help. I just wanted to skip that step and have the workbook
open up but I can live with it. thanks again!

 

[Dave Peterson]

Didn't last Friday's suggestion help?

I am having trouble hiding the personal workbook so I can open 2 or more
sessions of excel without getting the error that workbook is locked for
editing. I wrote a macro last week and can't get rid of the error.

 

[Mary C]

No. I did hide it but I still get the error that the personal workbook is
read only.

 

[Dave Peterson]

I guess you didn't check all the responses. I didn't suggest anything to do
with hiding a workbook.

No. I did hide it but I still get the error that the personal workbook is
read only.

 

[Mary C]

How do you get windows explorer to mark the macro workbook as readonly and
what is the personal.xla addin I have not heard of that before. As you can
tell I am just learning/ thanks again for your help.-
Mary C

 

[Dave Peterson]

Saving as an addin (in xl2003 menus):

Open excel
Window|Unhide (personal.xls)
File|SaveAs
Choose Addin from near the bottom of the list of file types
Save the personal file in the XLStart folder

Close excel
Go to the XLStart folder
Move personal.xls out of that folder. You don't want both of them in that
folder.

Reopen excel.

Start a second instance to see if it worked.

========

Marking the file as Readonly using Windows Explorer

Close excel
Open windows explorer
Go to that XLStart folder
Rightclick on personal.xls and choose properties.
General Tab
Change the Readonly property (near the bottom)

How do you get windows explorer to mark the macro workbook as readonly and
what is the personal.xla addin I have not heard of that before. As you can
tell I am just learning/ thanks again for your help.-
Mary C

 

[Mary C]

AWESOME!! The changing to readonly worked great!! I now can open 2
instances of excell without the readonly popping up. Thanks lots. I should
have kept up our conversation last week but I was going home and did not go
back in and recheck what you had written. Thanks again.

 

[Dave Peterson]

Remember that if you want to make changes to this personal.xls workbook, you'll
have to close excel, remove the readonly setting and then reopen excel and make
your changes.

Then remember to mark the file readonly when you're happy.

AWESOME!! The changing to readonly worked great!! I now can open 2
instances of excell without the readonly popping up. Thanks lots. I should
have kept up our conversation last week but I was going home and did not go
back in and recheck what you had written. Thanks again.
--
Mary C

Saving as an addin (in xl2003 menus):

Open excel
Window|Unhide (personal.xls)
File|SaveAs
Choose Addin from near the bottom of the list of file types
Save the personal file in the XLStart folder

Close excel
Go to the XLStart folder
Move personal.xls out of that folder. You don't want both of them in that
folder.

Reopen excel.

Start a second instance to see if it worked.

========

Marking the file as Readonly using Windows Explorer

Close excel
Open windows explorer
Go to that XLStart folder
Rightclick on personal.xls and choose properties.
General Tab
Change the Readonly property (near the bottom)