ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   missing the personal macro workbook option in excel? (https://www.excelbanter.com/excel-discussion-misc-queries/135949-missing-personal-macro-workbook-option-excel.html)

Todd

missing the personal macro workbook option in excel?
 
I'm missing the the personal macro workbook option in excel?

Dave Peterson

missing the personal macro workbook option in excel?
 
The personal.xls file won't exist until you create one.

If you created a personal.xls workbook and it's not opening, maybe...

xl2002+ has the abililty to quarantine what it thinks are bad workbooks.

They can keep track of them so that it doesn't even try to open them.

If you look under Help|About MS Excel, you'll see a button called: "Disabled
Items...".

Check under there to see if it's marked not to open. You can enable it there,
too.

If the workbook is really bad, you may want to delete that copy and put a copy
of your backup version into your XLStart folder.

(If you don't have a backup, take the time now and create one.)

Todd wrote:

I'm missing the the personal macro workbook option in excel?


--

Dave Peterson

Todd

missing the personal macro workbook option in excel?
 
Thanks, I'll give it ago.

"Dave Peterson" wrote:

The personal.xls file won't exist until you create one.

If you created a personal.xls workbook and it's not opening, maybe...

xl2002+ has the abililty to quarantine what it thinks are bad workbooks.

They can keep track of them so that it doesn't even try to open them.

If you look under Help|About MS Excel, you'll see a button called: "Disabled
Items...".

Check under there to see if it's marked not to open. You can enable it there,
too.

If the workbook is really bad, you may want to delete that copy and put a copy
of your backup version into your XLStart folder.

(If you don't have a backup, take the time now and create one.)

Todd wrote:

I'm missing the the personal macro workbook option in excel?


--

Dave Peterson


Todd

missing the personal macro workbook option in excel?
 
That worked, much thanks!

"Todd" wrote:

Thanks, I'll give it ago.

"Dave Peterson" wrote:

The personal.xls file won't exist until you create one.

If you created a personal.xls workbook and it's not opening, maybe...

xl2002+ has the abililty to quarantine what it thinks are bad workbooks.

They can keep track of them so that it doesn't even try to open them.

If you look under Help|About MS Excel, you'll see a button called: "Disabled
Items...".

Check under there to see if it's marked not to open. You can enable it there,
too.

If the workbook is really bad, you may want to delete that copy and put a copy
of your backup version into your XLStart folder.

(If you don't have a backup, take the time now and create one.)

Todd wrote:

I'm missing the the personal macro workbook option in excel?


--

Dave Peterson



All times are GMT +1. The time now is 07:15 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com