Roster movement in Universe mode

[dubbduces]

No message, I just can't click the button

[dubbduces]

Re: Roster movement in Universe mode

I'm guessing the lock has something to do with it?

[woodjer]

Re: Roster movement in Universe mode

I'm guessing the lock has something to do with it?

Hmmm...looks like you're working on a Mac. I don't see a lock on mine at all and I've opened it on a few different PCs. I'm guessing it's one of two things:
A) You need to enable macros. On the PC version, you can go to the File tab and then, under Info, you'll have an option to Enable Content. You might also get a message when you open the file that would allow you to Enable Content or Enable Macros.
B) My worksheet protection (so people don't end up breaking things) is causing problems.

I'd try option A first since I haven't had any problems with this file on other PCs and didn't need to turn off the protection. Hope this works.

[dubbduces]

Re: Roster movement in Universe mode

Trying to manually run the macros up in the top and I get this message

Or It just doesn't do anything....

[woodjer]

Re: Roster movement in Universe mode

Trying to manually run the macros up in the top and I get this message

Or It just doesn't do anything....

Well crap...maybe it isn't as ready as I thought. I'll see if I can use my wife's work Mac for a bit and try it out on that. In the meantime, could you post or PM me a screenshot of your setup screen? I don't know that you would have anything there that's causing this but it can't hurt to check.

Also, I'm assuming that you got that error the first time you tried to run it? It didn't start showing up on the 2nd or 3rd click, did it? Just trying to think of what might be causing this. Also trying to figure out why it's showing up on that sheet and not the Setup sheet where all of my testing errors were showing up.

[woodjer]

Re: Roster movement in Universe mode

Ok, I poked around a bit online and found a little info. Here's my first attempt at a fix...see if this helps. If not, I'll try a couple other things, too.

http://www.mediafire.com/?llf7a9h0dw9zyz8

[dubbduces]

Re: Roster movement in Universe mode

Well crap...maybe it isn't as ready as I thought. I'll see if I can use my wife's work Mac for a bit and try it out on that. In the meantime, could you post or PM me a screenshot of your setup screen? I don't know that you would have anything there that's causing this but it can't hurt to check.

Also, I'm assuming that you got that error the first time you tried to run it? It didn't start showing up on the 2nd or 3rd click, did it? Just trying to think of what might be causing this. Also trying to figure out why it's showing up on that sheet and not the Setup sheet where all of my testing errors were showing up.

Do you mean this?

[dubbduces]

Re: Roster movement in Universe mode

I just tried the new sheet. There is only one macro in the sheet and it works.

[woodjer]

Re: Roster movement in Universe mode

I just tried the new sheet. There is only one macro in the sheet and it works.

Just tried it out on my wife's Mac and couldn't get it to work there. She is using Office 2008 and that doesn't support Visual Basic for Applications(VBA...the code that I wrote to do everything). It looks like you're on 2011 but if not, that would be our issue right there.

I just realized something else though...I think I created that button as an ActiveX control but Office 2011 doesn't support those. Here is one where it isn't an ActiveX control and is just a regular form control. In the end, it should only require you to click the button on the Setup sheet.

http://www.mediafire.com/?mnj8f956bylh564

Sorry for the headaches...It's been 3-4 years since I wrote VBA code and I've never had to get it working on a Mac. We'll get it figured out though!

[dubbduces]

Re: Roster movement in Universe mode

Just tried it out on my wife's Mac and couldn't get it to work there. She is using Office 2008 and that doesn't support Visual Basic for Applications(VBA...the code that I wrote to do everything). It looks like you're on 2011 but if not, that would be our issue right there.

I just realized something else though...I think I created that button as an ActiveX control but Office 2011 doesn't support those. Here is one where it isn't an ActiveX control and is just a regular form control. In the end, it should only require you to click the button on the Setup sheet.

http://www.mediafire.com/?mnj8f956bylh564

Sorry for the headaches...It's been 3-4 years since I wrote VBA code and I've never had to get it working on a Mac. We'll get it figured out though!

Still not working, I've been trying to do some research, but I don't understand any of it....