Reminder

[Canon]

Excel 2007
I have an Excel file that when I open it, I have to manually change some
information and I would like to set up a reminder to make these changes as
soon as the file is opened. Is this possible?

 

[מיכ×ל (מיקי) ×בידן]

Consider using an Event Macro to be typed into ThisWorkbook Section

 

[Canon]

Thank you Micky, not very familiar with this - can you walk me through it?

 

[מיכ×ל (מיקי) ×בידן]

Why not...
* While the WB is open > press ALT+[F11].
* In the left Project Explorer window - resolve all branches and Double(!)
Click on ThisWorkBook.
* Paste the code into the Right Window and save the WB.
* Close and re-open the WB
Micky

 

[מיכ×ל (מיקי) ×בידן]

Why not...
* While the WB is open > press ALT+[F11].
* In the left Project Explorer window - resolve all branches and Double(!)
Click on ThisWorkBook.
* Paste the code into the Right Window and save the WB.
* Close and re-open the WB
Micky

 

[Canon]

Thanks again Micky, this works good... but I have to click on the Security
Alert and choose Enable this Content for it to work - can I eliminate this
step?

Why not...
* While the WB is open > press ALT+[F11].
* In the left Project Explorer window - resolve all branches and Double(!)
Click on ThisWorkBook.
* Paste the code into the Right Window and save the WB.
* Close and re-open the WB
Micky

Thank you Micky, not very familiar with this - can you walk me through it?

 

[מיכ×ל (מיקי) ×בידן]

Of course...
Click the round "Office" icon [Upper Left Corner] > 'Excel Options' > 'Trust
Center' >
'Trust Center Settings...' > 'Macro Settings' > choose 'Enable all Macros' >
'OK'.
Micky

Thanks again Micky, this works good... but I have to click on the Security
Alert and choose Enable this Content for it to work - can I eliminate this
step?

Why not...
* While the WB is open > press ALT+[F11].
* In the left Project Explorer window - resolve all branches and Double(!)
Click on ThisWorkBook.
* Paste the code into the Right Window and save the WB.
* Close and re-open the WB
Micky

Thank you Micky, not very familiar with this - can you walk me through it?

:

Consider using an Event Macro to be typed into ThisWorkbook Section
------------------------------------------------
Private Sub Workbook_Open()
MsgBox "Don't forget to make the Changes"
End Sub
------------------
Micky


:

Excel 2007
I have an Excel file that when I open it, I have to manually change some
information and I would like to set up a reminder to make these changes as
soon as the file is opened. Is this possible?

 

[Gord Dibben]

I find it safer to leave macro security at "disable with notification" and
place the workbook in a Trusted Location.

You will still be protected from malicious macros from non-trusted locations
but those workbooks in the trusted locations will open without warning.


Gord Dibben MS Excel MVP

Of course...
Click the round "Office" icon [Upper Left Corner] > 'Excel Options' > 'Trust
Center' >
'Trust Center Settings...' > 'Macro Settings' > choose 'Enable all Macros' >
'OK'.
Micky

Thanks again Micky, this works good... but I have to click on the Security
Alert and choose Enable this Content for it to work - can I eliminate this
step?

Why not...
* While the WB is open > press ALT+[F11].
* In the left Project Explorer window - resolve all branches and Double(!)
Click on ThisWorkBook.
* Paste the code into the Right Window and save the WB.
* Close and re-open the WB
Micky


:

Thank you Micky, not very familiar with this - can you walk me through it?

:

Consider using an Event Macro to be typed into ThisWorkbook Section
------------------------------------------------
Private Sub Workbook_Open()
MsgBox "Don't forget to make the Changes"
End Sub
------------------
Micky


:

Excel 2007
I have an Excel file that when I open it, I have to manually change some
information and I would like to set up a reminder to make these changes as
soon as the file is opened. Is this possible?