View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Craig Craig is offline
external usenet poster
 
Posts: 208
Default Open VBA Editor?

apologies if i was not clear....i am trying to assist colleagues in writing
simple code. From a Userform i have done i want to include a button that when
clicked will take the user straight to 'view code' so they can input examples
of code i have prepared for them....trying to get more people to see how
useful vba can be!!!!!!

"OssieMac" wrote:

Hi Craig,

Do you mean with a button in the QAT (Quick Access Toolbar)? If so, right
click the blank space at end of QAT - Customize Quick Access Toolbar - In
the Choose commands from select All commands. Find Visual Basic and Add it.

--
Regards,

OssieMac


"Craig" wrote:

Hi,

Is there a way I can open the vba editor from a command button?