Results 1 to 5 of 5
  1. #1
    Silver Lounger
    Join Date
    Jan 2001
    Location
    Northern, California, USA
    Posts
    1,886
    Thanks
    0
    Thanked 0 Times in 0 Posts

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

    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!
    <IMG SRC=http://www.wopr.com/w3tuserpics/Kel_sig.gif>
    Moderator:<font color=448800> Pix Place, Internet Explorer</font color=448800>
    <small>www.kvisions.com

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Excel's (Normal.Dot) (97 SR2)

    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

  3. #3
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel's (Normal.Dot) (97 SR2)

    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.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  4. #4
    Lounger
    Join Date
    Aug 2002
    Location
    Boise, Idaho, USA
    Posts
    38
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel's (Normal.Dot) (97 SR2)

    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...

  5. #5
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel's (Normal.Dot) (97 SR2)

    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
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •