How to Attach Module with Excel
Closed
Soail_3236
-
Apr 16, 2010 at 03:37 AM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Apr 16, 2010 at 06:10 AM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Apr 16, 2010 at 06:10 AM
Related:
- How to Attach Module with Excel
- How to take screenshot in excel - Guide
- Number to words in excel - Guide
- Excel date format dd.mm.yyyy - Guide
- How to change author in excel - Guide
- Excel free download - Download - Spreadsheets
1 response
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Apr 16, 2010 at 06:10 AM
Apr 16, 2010 at 06:10 AM
I think you cannot activate a"module" ony activate one or more macros in the module
if you want to activate a module when you open the workbook
open vb editor (alt+F11)
hit control+R
on the left side the project window opens
go to your file whose name is there
in the list of projects under your file there is a term "thisworkbook"
right click this term and click view code
right hand side blank window opens
in this window there are two small windows on left and right
on the left side click that small arrow and choose "workbook"
automatically these statements will appear
the macro need not be in this window but should be available in the module of that particular file.
so when you open the file automatically that macro will run.
if you want to activate a module when you open the workbook
open vb editor (alt+F11)
hit control+R
on the left side the project window opens
go to your file whose name is there
in the list of projects under your file there is a term "thisworkbook"
right click this term and click view code
right hand side blank window opens
in this window there are two small windows on left and right
on the left side click that small arrow and choose "workbook"
automatically these statements will appear
Private Sub Workbook_Open() <here type the name of the macro> End Sub
the macro need not be in this window but should be available in the module of that particular file.
so when you open the file automatically that macro will run.
