Macro help working in windows not Mac

[dorabajji]

Hi,
I have a simple macro of adding to another sheet and removing, it is working in windows excel but not mac.
I am a window user. Can anybody test it in mac, if you are mac user.
Let me know, if anybody using mac- i will attach the file.
Macro is simple, take reference from sheet 1 to sheet2 on click of buttons

[rorya]

Why not just post the code? And explain exactly what “not working” means. (I assume you know activex buttons will not work on a Mac)

[dorabajji]

Yes, I know.. thats y used form buttons..
Will post code
Hi roya.. i added the code in file sheet 1 as i got error while posting in the editor forum

[rorya]

You haven’t explained what the problem is?

[dorabajji]

Hi Roya,
I was informed that original file is opening in read only and the buttons are not working.( i use form controls button and not activex)
and i want to know, is there any changes when coding in mac.. like reference (variable declaration and sheet reference)..
or what i have done is ok for mac?

In total 3 macros, all does the same kind of functionality but reference is difference sheet.
It is like form entering a1 go to respective sheet based on macro

[rorya]

The code you posted should be fine on a Mac. If the buttons don’t work at all (ie they just act like pictures) then I’d have to assume they are activex not Form.

Can you post the actual file, please? And do you know which version of Mac Office it is to be used on?

[dorabajji]

Hi,
Copied all the code and buttons in this file.. Replica of the original file

[dorabajji]

Hi Roya,
Is the file working? is there any changes needed?

[rorya]

Apologies - I had to wait until my children had finished their schoolwork to get at my Macs!

All the buttons work fine on my Mac.

[dorabajji]

Hi Rorya ,
Thanks a lot..