Hiding the personal workbook

  • Thread starter Thread starter Mary C
  • Start date Start date
M

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.
 
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.
Click to expand...

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
 
I have opened the person workbook and it is hidden so where do I go from here?
--
Mary C







- Show quoted text -
Click to expand...

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
 
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!
 
Didn't last Friday's suggestion help?

Mary said:
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.
Click to expand...
 
I guess you didn't check all the responses. I didn't suggest anything to do
with hiding a workbook.

Mary said:
No. I did hide it but I still get the error that the personal workbook is
read only.
Click to expand...
 
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
 
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)

Mary said:
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
Click to expand...
 
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.
 
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.

Mary said:
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

Dave Peterson said:
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)
Click to expand...
Click to expand...
 
Back
Top