VBA is not in excel 2008 for mac, how do I create "mouseclick-macros"

[PalleJ]

Hi
being used for 20 years to excel, its inconvenient that macros are no
longer an option in the "Home" version, am not looking for big fancy
ones, but would really like to be able to automate some mousecliks.
for example: marking 20 coloums and then hide them, and another one
unhiding them. I used to have these two assigned to a "button" but a
key shortcut would do.

do anyone have a clue on how to do this?

I have no experience on how to write apple scripts or use automator,
maybe a 3'rd party software can do it? should be a market, I cant be
the only one missing the VBA option, (newsgroups shows many request bu
no solution)

 

[Bob Greenblatt]

Hi
being used for 20 years to excel, its inconvenient that macros are no
longer an option in the "Home" version, am not looking for big fancy
ones, but would really like to be able to automate some mousecliks.
for example: marking 20 coloums and then hide them, and another one
unhiding them. I used to have these two assigned to a "button" but a
key shortcut would do.

do anyone have a clue on how to do this?

I have no experience on how to write apple scripts or use automator,
maybe a 3'rd party software can do it? should be a market, I cant be
the only one missing the VBA option, (newsgroups shows many request bu
no solution)

You are not the only one missing VBA; and it is missing from ALL of Office
2008, not just the home edition. You can do exactly what you want using the
old XLM macro language. However, there is no current documentation or "how
to" books. If you can explain in detail what you need I will post an XLM
solution to get you started.

 

[Patrick]

Hello Bob,
May i know how to give actions to buttons in Excel 2008?

 

[PalleJ]

You are not the only one missing VBA; and it is missing from ALL of Office
2008, not just the home edition. You can do exactly what you want using the
old XLM macro language. However, there is no current documentation or "how
to" books. If you can explain in detail what you need I will post an XLM
solution to get you started.

Hi Bob
great you may help me.
what I have done in vba (record macro) is simply cliking and tereby
highligting coloumn L to coloumn AC and then hiding them! And another
similar to unhide them.
the use is simple.
I have a spreadsheet with at list of people. in coloumn AJ i have
formulas with COUNTVALUE, which gives 1 if there is a name entered and
0 if not, these results ar then summed up and the sum will be the
number of persons entered with name. (there are more complx formulas
too, but this does not matter for hiding / unhiding.

the reason I put these formulas so far out was to avoid the daily
users to overwrite formulas by accident. So its only when I need to
chec the integrity of formulas i need the hide.
can this xml you foresee be given a shortcut or a button? I use two
custom buttobs today in the office XP

hope i made myself clear and not gave you a smokescreen

are there really no cookbokks left for xml?

Palle

 

[roblake]

At www.powells.com, I entered XML and got hundreds of books identified. O'Reilly has several, including a Nutshell series.

 

[Niek Otten]

Now enter XLM (which is what the OP needs) instead of XML; No matches.

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| At www.powells.com, I entered XML and got hundreds of books identified. O'Reilly has several, including a Nutshell series.

 

[sketchturner]

I have the XLM reference, which you can actually download from MS's site at
<http://www.microsoft.com/downloads/...43-3AD1-4DF1-9F93-C19C7E84F01C&displaylang=en>

It is in an old SIT archive, you will need to find an app to extract those files.

Once you see the reference what you want to do will be fairly easy. If you need help i can send you a couple of samples to your mail.

Cheers!
Manuel