Excel’s (Normal.Dot) (97 SR2)

Topic

New Reply

What is the excel equivalent of Normal.Dot?

I’d like to modify the base excel file so that every time it loads, it sets application.ignoreremoterequests = false.

Thanks!

Reply | Quote

Replies

The default workbook is “Book.xlt” and is stored in the xlstart folder.
The default workbook is “Sheet.xlt” and is stored in the xlstart folder.

They might not be there. If they are not (typical) excel will base it on default system settings.
Add the macro
Private Sub Workbook_Open()
application.ignoreremoterequests = false
End Sub

and anything else ( pictures, even fill in cells), save as template, in XLStart.

Steve

Reply | Quote

The code is OK, but I would put it in the file Personal.xls. As it is now you’ll have this code in every workbook you’ll create and thus every workbook will show the macro warning message.

You can get to personal.xls by activating the VBE. If it is not there, go back to excel, record a bogus macro making sure you select to store it in your personal macro workbook. Excel then creates this workbook. Now open the Thisworkbook module of personal.xls and paste in the code. Close Excel and confirm to save changes to personal.xls.

Reply | Quote

Personal.xls defaults as a hidden workbook. It’s true that you can still access it by opening the VBE and using the Project Explorer. But if you were thinking of getting to it from Excel by using

Tools/Macro/Macros…/Edit,

you’ll need to unhide the workbook first:

Window/Unhide…

Reply | Quote

True.

But you’ll have to remember to hide it again before saving.

For that purpose I have this little sub in Personal.xls:

Sub HideAndSave()
With Thisworkbook
.Windows(1).Visible = False
.Save
End With
End Sub

Reply | Quote