Reminder

  • Thread starter Thread starter Canon
  • Start date Start date
C

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

מיכ×ל (מיקי) ×בידן said:
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 said:
Thank you Micky, not very familiar with this - can you walk me through it?
Click to expand...
Click to expand...
 
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


Canon said:
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?

מיכ×ל (מיקי) ×בידן said:
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 said:
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?
Click to expand...
Click to expand...
Click to expand...
 
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


Canon said:
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?

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