Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do I input codes?
I see that I can do various things by inputting a code, but I don't know
where do I actually input a code. How do I actually input a code (say for example, to lock or unlock all worksheets within a workbook)? I have the code -- I just don't know where to put it. Thanks in advance! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do I input codes?
Macros are very easy to install and use: 1. ALT-F11 brings up the VBE window 2. ALT-I ALT-M opens a fresh module 3. paste the stuff in and close the VBE window If you save the workbook, the macro will be saved with it. To use the macro from the normal Excel window: 1. ALT-F8 2. Select the macro 3. Touch Run To remove the macro: 1. bring up the VBE window as above 2. clear the code out 3. close the VBE window -- Gary''s Student - gsnu200842 "Venus" wrote: I see that I can do various things by inputting a code, but I don't know where do I actually input a code. How do I actually input a code (say for example, to lock or unlock all worksheets within a workbook)? I have the code -- I just don't know where to put it. Thanks in advance! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do I input codes?
Full instructions on placement of various types of code here at Ron de
Bruin's site. http://www.rondebruin.nl/code.htm Gord Dibben MS Excel MVP On Wed, 1 Apr 2009 08:34:11 -0700, Venus wrote: I see that I can do various things by inputting a code, but I don't know where do I actually input a code. How do I actually input a code (say for example, to lock or unlock all worksheets within a workbook)? I have the code -- I just don't know where to put it. Thanks in advance! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
input in number form is being multiplied by 1000 when i input. | Excel Discussion (Misc queries) | |||
Have user input converted to uppercase in same cell as input? | New Users to Excel | |||
I need to input daily cost codes would exceli calculate my totals | Excel Worksheet Functions | |||
how do I input zip codes with a leading zero | New Users to Excel | |||
=SUMIF(Input!H2:H718,AZ19,Input!E2:E685)AND(IF | Excel Worksheet Functions |