Continue to Site

Eng-Tips is the largest engineering community on the Internet

Intelligent Work Forums for Engineering Professionals

Register Log in
  • Congratulations KootK on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!

Start-up Macro

Status
Not open for further replies.
d23

d23

Petroleum
Dec 8, 2002
297
All,

I need to run a text disclaimer on start-up. Can I make a macro run when a file opens that would display text only? What I am looking for is a command similar to \0 in Lotus.

Thanks

D23
 
Replies continue below

Recommended for you

Sort by date Sort by votes
If you mean for Excel, then you want an event-macro. The one you're looking for is "workbook open."
 
Upvote 0 Downvote
MintJulep and francesca,

Thank you for your replies!!!

With your recommendations I was able to dig a little deeper and found the “Workbook_Open()" function in VBA. This does what I need. I am opening the file on a new sheet with my disclaimer and have included a macro button that moves to the data input sheet.

Once again thank you for your help!

D23
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

BhagyeshVashi
  • Locked
  • Question
Need a rename macro for excel
Replies
11
Views
525
sdz
sdz
JayEnn1
  • Locked
  • Question
Excel macro worked great with Outlook, need update help for Windows 10 Mail App
Replies
5
Views
92
JayEnn1
JayEnn1
Celt83
  • Locked
  • Question
[Excel] [Macro Enabled] Rigid Plate Analysis 1
Replies
14
Views
191
yakpol
yakpol
electricpete
  • Locked
  • Question
an update to vba routine for highlighting the current cell 3
Replies
6
Views
119
skeletron
skeletron
phamENG
  • Locked
  • Question
Auto-Updating Template
Replies
11
Views
79
Tuckabag
Tuckabag

Part and Inventory Search

Sponsor

Back
Top Bottom