| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
run macro on opening
Hi
(originally put in wrong grouping) I have go this off other threads, but would like it to run automatically when opening the workbook. I am not up to speed with these codes, and therefore ask if the additional line/lines could be added in the correct place, in order that I can copy and Paste. Currently, I have to run this every time after opening the workbook Option Explicit Sub auto_open() With Worksheets("sheet1") .Protect Password:="test", userinterfaceonly:=True .EnableAutoFilter = True End With End Sub Can anyone help?, Brian -- bnt Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...excel/200612/1 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| opening access database using macro | New Users to Excel | |||
| Closing File Error | Excel Discussion (Misc queries) | |||
| Opening a file in a macro (network) | Excel Discussion (Misc queries) | |||
| Macro warning (upon opening) | Excel Discussion (Misc queries) | |||
| After deleting a macro, I still get the pop-up when opening file | Excel Worksheet Functions | |||
Threaded Mode
