Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro
Just a simple question regard Macro.
I have a file that whenever i opens, it prompts me on Macro, 1) what is macro. i have checked macro, it stated security level, virus prevention. 2)so what do macro actually do? it is necessary? 3) how do i disable macro? so that i can just open my file without selecting enable marco or disable macro. 4) base on point 3, it is safe enough if i remove macro? THANKS |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro
A macro is like a recording. When you start up a macro it records what you do
on excel. So if you type "Hello" in to cell A1. The macro records that and when you go to play the macro it types "Hello" in to A1 every single time. You don't really have to turn them off unless there is an class module, which lots of times there isn't. But if you really want to turn them off go to Tools--- Macro--- Macros Then to your left you should see a project explorer window. If you find the workbook that you have open, you will see a list of modules or userforms... just click on those and delete those entire modules. Make sure there isn't anything significiantly tied to them, because once you delete them, it would be a biatch to recreate them. "kyoshirou" wrote: Just a simple question regard Macro. I have a file that whenever i opens, it prompts me on Macro, 1) what is macro. i have checked macro, it stated security level, virus prevention. 2)so what do macro actually do? it is necessary? 3) how do i disable macro? so that i can just open my file without selecting enable marco or disable macro. 4) base on point 3, it is safe enough if i remove macro? THANKS |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro
Hi kyoshirou,
Others may be able to advise further or better, but I'll just say that you can safely turn off macros. In fact it's the safest way to operate Excel and that's why so many security options are in place. Macros in Excel are known as Visual Basic code and it contains instructions to perform certain tasks at the click of a button. If a file has macros, and you disable them, you can still use the file, but the function that the macros do will not be able to be accessed, and you will lose functionality which you may, or may not need. Rob "kyoshirou" wrote in message ... Just a simple question regard Macro. I have a file that whenever i opens, it prompts me on Macro, 1) what is macro. i have checked macro, it stated security level, virus prevention. 2)so what do macro actually do? it is necessary? 3) how do i disable macro? so that i can just open my file without selecting enable marco or disable macro. 4) base on point 3, it is safe enough if i remove macro? THANKS |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro
Hi Both,
What are the functions, or how can i check what's the function is the file supporting? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro
kyoshirou,
You could check what the macros are, if any, by clicking View on the menubar and select Macros. That should show you the names of the macros stored in the workbook. You can then select edit as desired and see their content. You can also run each macro and that may tell you waht they do. Is this a file someone you know constructed? If it's from an unknown source you may even find that the macros are password protected which means you won't be able to see the code but may only be able to run the macro. Rob "kyoshirou" wrote in message ... Hi Both, What are the functions, or how can i check what's the function is the file supporting? |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro
Hello Rob
How to i go to menubar view? My view only display Worksheet. Chart, Function, Name and Pictures. I using version 2002. Yes, this file is constructed by someone whom i dont know. haha Thanks! You could check what the macros are, if any, by clicking View on the menubar and select Macros. That should show you the names of the macros stored in the workbook. You can then select edit as desired and see their content. You can also run each macro and that may tell you waht they do. Is this a file someone you know constructed? If it's from an unknown source you may even find that the macros are password protected which means you won't be able to see the code but may only be able to run the macro. Rob "kyoshirou" wrote in message ... Hi Both, What are the functions, or how can i check what's the function is the file supporting? |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro
kyoshirou,
This is getting a bit hard for me now. I don't have your version. You could try to hold down the Alt key and press the F11 key. OR right click a sheet tab and select view code. This will take you to the Macro area. On the left should be a list of the worksheets. There may also be a list of Modules, etc. If you click or double click those you should find one or more that contain some code. On the toolbar of that macro section you can click the button to run each macro as you find them to see what they do. It may be possible they are passworded, etc. It depends where you got the file from. If you share the source with us it may help. If none of what I proposes works, I might suggest you have a protected file of some description, and that sort of stuff has been hidden. Rob "kyoshirou" wrote in message ... Hello Rob How to i go to menubar view? My view only display Worksheet. Chart, Function, Name and Pictures. I using version 2002. Yes, this file is constructed by someone whom i dont know. haha Thanks! You could check what the macros are, if any, by clicking View on the menubar and select Macros. That should show you the names of the macros stored in the workbook. You can then select edit as desired and see their content. You can also run each macro and that may tell you waht they do. Is this a file someone you know constructed? If it's from an unknown source you may even find that the macros are password protected which means you won't be able to see the code but may only be able to run the macro. Rob "kyoshirou" wrote in message ... Hi Both, What are the functions, or how can i check what's the function is the file supporting? |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro
Rob San,
i managed to get these coding: Private Sub CheckBox1_Click() End Sub Private Sub Worksheet_BeforeRightClick(ByVal Target As Range, Cancel As Boolean) End Sub Private Sub Worksheet_SelectionChange(ByVal Target As Range) End Sub ---------------------------------------------------------------------------------- How come the coding so short? Do u know what is the programming trying to output? "RobN" wrote: kyoshirou, This is getting a bit hard for me now. I don't have your version. You could try to hold down the Alt key and press the F11 key. OR right click a sheet tab and select view code. This will take you to the Macro area. On the left should be a list of the worksheets. There may also be a list of Modules, etc. If you click or double click those you should find one or more that contain some code. On the toolbar of that macro section you can click the button to run each macro as you find them to see what they do. It may be possible they are passworded, etc. It depends where you got the file from. If you share the source with us it may help. If none of what I proposes works, I might suggest you have a protected file of some description, and that sort of stuff has been hidden. Rob "kyoshirou" wrote in message ... Hello Rob How to i go to menubar view? My view only display Worksheet. Chart, Function, Name and Pictures. I using version 2002. Yes, this file is constructed by someone whom i dont know. haha Thanks! You could check what the macros are, if any, by clicking View on the menubar and select Macros. That should show you the names of the macros stored in the workbook. You can then select edit as desired and see their content. You can also run each macro and that may tell you waht they do. Is this a file someone you know constructed? If it's from an unknown source you may even find that the macros are password protected which means you won't be able to see the code but may only be able to run the macro. Rob "kyoshirou" wrote in message ... Hi Both, What are the functions, or how can i check what's the function is the file supporting? |
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro
kyoshirou,
I think somebody has been trying a few things with this file and you've ended up with codes that do nothing, probably because they deleted all the code procedures! What you have left will do nothing without further code being added. Each Code procedure starts with a heading, such as "Private Sub Worksheet_SelectionChange(ByVal Target As Range)" and will have an ending such as "End Sub" with some code in between that performs certain procedures (but they're missing). In short, I suggest you ignore the code in this file as it is incomplete and does nothing. Rob "kyoshirou" wrote in message ... Rob San, i managed to get these coding: Private Sub CheckBox1_Click() End Sub Private Sub Worksheet_BeforeRightClick(ByVal Target As Range, Cancel As Boolean) End Sub Private Sub Worksheet_SelectionChange(ByVal Target As Range) End Sub ---------------------------------------------------------------------------------- How come the coding so short? Do u know what is the programming trying to output? "RobN" wrote: kyoshirou, This is getting a bit hard for me now. I don't have your version. You could try to hold down the Alt key and press the F11 key. OR right click a sheet tab and select view code. This will take you to the Macro area. On the left should be a list of the worksheets. There may also be a list of Modules, etc. If you click or double click those you should find one or more that contain some code. On the toolbar of that macro section you can click the button to run each macro as you find them to see what they do. It may be possible they are passworded, etc. It depends where you got the file from. If you share the source with us it may help. If none of what I proposes works, I might suggest you have a protected file of some description, and that sort of stuff has been hidden. Rob "kyoshirou" wrote in message ... Hello Rob How to i go to menubar view? My view only display Worksheet. Chart, Function, Name and Pictures. I using version 2002. Yes, this file is constructed by someone whom i dont know. haha Thanks! You could check what the macros are, if any, by clicking View on the menubar and select Macros. That should show you the names of the macros stored in the workbook. You can then select edit as desired and see their content. You can also run each macro and that may tell you waht they do. Is this a file someone you know constructed? If it's from an unknown source you may even find that the macros are password protected which means you won't be able to see the code but may only be able to run the macro. Rob "kyoshirou" wrote in message ... Hi Both, What are the functions, or how can i check what's the function is the file supporting? |
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro
Rob,
How do i remove the macro? Actually to have the macro or not does not matter right? "RobN" wrote: kyoshirou, I think somebody has been trying a few things with this file and you've ended up with codes that do nothing, probably because they deleted all the code procedures! What you have left will do nothing without further code being added. Each Code procedure starts with a heading, such as "Private Sub Worksheet_SelectionChange(ByVal Target As Range)" and will have an ending such as "End Sub" with some code in between that performs certain procedures (but they're missing). In short, I suggest you ignore the code in this file as it is incomplete and does nothing. Rob "kyoshirou" wrote in message ... Rob San, i managed to get these coding: Private Sub CheckBox1_Click() End Sub Private Sub Worksheet_BeforeRightClick(ByVal Target As Range, Cancel As Boolean) End Sub Private Sub Worksheet_SelectionChange(ByVal Target As Range) End Sub ---------------------------------------------------------------------------------- How come the coding so short? Do u know what is the programming trying to output? "RobN" wrote: kyoshirou, This is getting a bit hard for me now. I don't have your version. You could try to hold down the Alt key and press the F11 key. OR right click a sheet tab and select view code. This will take you to the Macro area. On the left should be a list of the worksheets. There may also be a list of Modules, etc. If you click or double click those you should find one or more that contain some code. On the toolbar of that macro section you can click the button to run each macro as you find them to see what they do. It may be possible they are passworded, etc. It depends where you got the file from. If you share the source with us it may help. If none of what I proposes works, I might suggest you have a protected file of some description, and that sort of stuff has been hidden. Rob "kyoshirou" wrote in message ... Hello Rob How to i go to menubar view? My view only display Worksheet. Chart, Function, Name and Pictures. I using version 2002. Yes, this file is constructed by someone whom i dont know. haha Thanks! You could check what the macros are, if any, by clicking View on the menubar and select Macros. That should show you the names of the macros stored in the workbook. You can then select edit as desired and see their content. You can also run each macro and that may tell you waht they do. Is this a file someone you know constructed? If it's from an unknown source you may even find that the macros are password protected which means you won't be able to see the code but may only be able to run the macro. Rob "kyoshirou" wrote in message ... Hi Both, What are the functions, or how can i check what's the function is the file supporting? |
#11
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro
When you record a macro, Excel creates a module in which the code is
stored. When you delete the macro, the module is not automatically deleted. There are instructions here for finding and removing code: http://www.contextures.com/xlfaqMac.html#NoMacros kyoshirou wrote: Rob, How do i remove the macro? Actually to have the macro or not does not matter right? "RobN" wrote: kyoshirou, I think somebody has been trying a few things with this file and you've ended up with codes that do nothing, probably because they deleted all the code procedures! What you have left will do nothing without further code being added. Each Code procedure starts with a heading, such as "Private Sub Worksheet_SelectionChange(ByVal Target As Range)" and will have an ending such as "End Sub" with some code in between that performs certain procedures (but they're missing). In short, I suggest you ignore the code in this file as it is incomplete and does nothing. Rob "kyoshirou" wrote in message ... Rob San, i managed to get these coding: Private Sub CheckBox1_Click() End Sub Private Sub Worksheet_BeforeRightClick(ByVal Target As Range, Cancel As Boolean) End Sub Private Sub Worksheet_SelectionChange(ByVal Target As Range) End Sub ---------------------------------------------------------------------------------- How come the coding so short? Do u know what is the programming trying to output? "RobN" wrote: kyoshirou, This is getting a bit hard for me now. I don't have your version. You could try to hold down the Alt key and press the F11 key. OR right click a sheet tab and select view code. This will take you to the Macro area. On the left should be a list of the worksheets. There may also be a list of Modules, etc. If you click or double click those you should find one or more that contain some code. On the toolbar of that macro section you can click the button to run each macro as you find them to see what they do. It may be possible they are passworded, etc. It depends where you got the file from. If you share the source with us it may help. If none of what I proposes works, I might suggest you have a protected file of some description, and that sort of stuff has been hidden. Rob "kyoshirou" wrote in message ... Hello Rob How to i go to menubar view? My view only display Worksheet. Chart, Function, Name and Pictures. I using version 2002. Yes, this file is constructed by someone whom i dont know. haha Thanks! You could check what the macros are, if any, by clicking View on the menubar and select Macros. That should show you the names of the macros stored in the workbook. You can then select edit as desired and see their content. You can also run each macro and that may tell you waht they do. Is this a file someone you know constructed? If it's from an unknown source you may even find that the macros are password protected which means you won't be able to see the code but may only be able to run the macro. Rob "kyoshirou" wrote in message ... Hi Both, What are the functions, or how can i check what's the function is the file supporting? -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
#12
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro
isee..
thanks! "Debra Dalgleish" wrote: When you record a macro, Excel creates a module in which the code is stored. When you delete the macro, the module is not automatically deleted. There are instructions here for finding and removing code: http://www.contextures.com/xlfaqMac.html#NoMacros kyoshirou wrote: Rob, How do i remove the macro? Actually to have the macro or not does not matter right? "RobN" wrote: kyoshirou, I think somebody has been trying a few things with this file and you've ended up with codes that do nothing, probably because they deleted all the code procedures! What you have left will do nothing without further code being added. Each Code procedure starts with a heading, such as "Private Sub Worksheet_SelectionChange(ByVal Target As Range)" and will have an ending such as "End Sub" with some code in between that performs certain procedures (but they're missing). In short, I suggest you ignore the code in this file as it is incomplete and does nothing. Rob "kyoshirou" wrote in message ... Rob San, i managed to get these coding: Private Sub CheckBox1_Click() End Sub Private Sub Worksheet_BeforeRightClick(ByVal Target As Range, Cancel As Boolean) End Sub Private Sub Worksheet_SelectionChange(ByVal Target As Range) End Sub ---------------------------------------------------------------------------------- How come the coding so short? Do u know what is the programming trying to output? "RobN" wrote: kyoshirou, This is getting a bit hard for me now. I don't have your version. You could try to hold down the Alt key and press the F11 key. OR right click a sheet tab and select view code. This will take you to the Macro area. On the left should be a list of the worksheets. There may also be a list of Modules, etc. If you click or double click those you should find one or more that contain some code. On the toolbar of that macro section you can click the button to run each macro as you find them to see what they do. It may be possible they are passworded, etc. It depends where you got the file from. If you share the source with us it may help. If none of what I proposes works, I might suggest you have a protected file of some description, and that sort of stuff has been hidden. Rob "kyoshirou" wrote in message ... Hello Rob How to i go to menubar view? My view only display Worksheet. Chart, Function, Name and Pictures. I using version 2002. Yes, this file is constructed by someone whom i dont know. haha Thanks! You could check what the macros are, if any, by clicking View on the menubar and select Macros. That should show you the names of the macros stored in the workbook. You can then select edit as desired and see their content. You can also run each macro and that may tell you waht they do. Is this a file someone you know constructed? If it's from an unknown source you may even find that the macros are password protected which means you won't be able to see the code but may only be able to run the macro. Rob "kyoshirou" wrote in message ... Hi Both, What are the functions, or how can i check what's the function is the file supporting? -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro Help Needed - Excel 2007 - Print Macro with Auto Sort | Excel Worksheet Functions | |||
My excel macro recorder no longer shows up when recording macro | Excel Discussion (Misc queries) | |||
using a cell value to control a counter inside a macro and displaying macro value | Excel Worksheet Functions | |||
Macro needed to Paste Values and prevent Macro operation | Excel Discussion (Misc queries) | |||
Macro needed to Paste Values and prevent Macro operation | Excel Discussion (Misc queries) |