Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

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

Can the Excel File Macro menu item be used like an ActiveX object

Status
Not open for further replies.
SBendBuckeye

SBendBuckeye

Programmer
May 22, 2002
2,166
US
I have a nervous Nellie user who is easily intimidated. He would benefit greatly from doing some formatting macros, etc. for standard processing he does but will never do it.

I would like to hide the record macro, stop macro, etc behind a User form which I could make a little bit more friendly for him. But all it would do in the background is start and stop macro recording and then pop a list for him to use.

Is this type of thing doable? If so, can someone point me or give me some ideas or suggestions?

Thanks in advance and have a great weekend!

 
Status
Not open for further replies.

Similar threads

remeng
  • Locked
  • Solved
Run-time error '429': ActiveX component can't create object From Excel to Word
Replies
9
Views
1K
remeng
remeng
morechocolate
  • Locked
  • Question
run-tune error 3704 operation is not allowed when the object is codes: I don't think so.
Replies
7
Views
1K
morechocolate
morechocolate
remeng
  • Locked
  • Question
CTRL + BREAK from second macro button
Replies
5
Views
691
strongm
strongm
remeng
  • Locked
  • Helpful tip
Microsoft Office 365 Word Macro Causing a Project is unviewable error
Replies
1
Views
1K
dhookom
dhookom
remeng
  • Locked
  • Question
Excel VBA to Pass Var between file macros after var changes
Replies
13
Views
617
mikrom
mikrom

Part and Inventory Search

Sponsor

Back
Top