• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

HELP! Where do I put the code

Status
Not open for further replies.

Debraj

Excel Ninja
* If Developer Tab Is not in the ribbon..
  • Open Excel.
  • Go to VBA Editor (press Alt + F11)
  • Go to Immediate Window. ( Ctrl + G)
  • Write below Code.
Application.ShowDevTools = True
* How to Insert VBA code in Excel
  • Go to Developer Tab > Code Group > Visual Basic
  • Click Insert > Module.
  • Will open a Blank Module for you.
  • Write / Paste provided code in that Module
Insert.jpg

* How to Run a Macro
  • Select anywhere in between the Code, Sub… End Sub
  • Click Run & Run Sub or F5
Run.jpg

* How to assign a Macro
  • Insert any picture / shape.
  • Right click the inserted picture and assign desired Macro
14-12-2013 02-50-47.png
 
Last edited:
Status
Not open for further replies.
Top