![]() |
#2
|
||||
|
||||
![]()
In answer to Q1, the best book on Word VBA that I ever read was the first one - Word 97 Annoyances by Woody Leonhard. It was very readable and changed my mindset on how to interact with the software. I believe it would be an awesome starting point despite the fact that it is over 25 years old. Once you have that under your belt, you could simply review forums and look at code that gets posted in response to people's questions. That plus recording macros is all I have used since then.
Making links to run VBA via buttons is clunky and not the preferred way. A simpler way to kick off macros by clicking in the document is a MacroButton field. However, forcing users to enable macros to get functionality is against the principles of safe web use so users need to see real value in enabling that functionality. Because the same functionality could be done without macros, it would be hard to justify the business case of requiring macros. If you have a close relationship with the IT group running the network you could sign the macros and have certificate public keys loaded on their machines or have trusted folders for templates to smooth out some of those issues but it remains a risk. I would simply add Cross-References or Hyperlinks to Bookmarks to do the same thing unless there are other reasons to force users to enable VBA macros.
__________________
Andrew Lockton Chrysalis Design, Melbourne Australia |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Hiding Command Buttons before PDF | ksigcajun | Word VBA | 3 | 05-07-2014 05:31 AM |
![]() |
chcope | PowerPoint | 2 | 06-13-2013 04:30 PM |
Command Buttons | lorenambrose | Word | 0 | 10-06-2011 11:55 AM |
command buttons | ronf | Excel | 0 | 04-28-2006 08:32 AM |
command buttons | ronf | Excel | 0 | 12-03-2005 06:26 AM |