Macro

[Guest]

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

 

[Guest]

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.

 

[RobN]

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

 

[Guest]

Hi Both,

What are the functions, or how can i check what's the function is the file
supporting?

 

[RobN]

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

 

[Guest]

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!

 

[RobN]

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

 

[Guest]

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 Su

 

[RobN]

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

 

[Guest]

Rob,
How do i remove the macro?
Actually to have the macro or not does not matter right?

 

[Debra Dalgleish]

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

 

[Guest]

isee..
thanks!

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