Posts by: Thomas W

Re: Shortcut Keys for Macros Not Working
Disabling Bloomberg Excel Tools allowed WST Macros to work. Thank you so much! I'm not 100% what I disabled but I'm psyched the tools work again.
Go to post added 7 years ago
Re: Shortcut Keys for Macros Not Working
Yes the Bloomberg Excel Tools is there and also checked.
Go to post added 7 years ago
Re: Shortcut Keys for Macros Not Working
Thanks again. I'm sorry, I did that and it isn't working. The WST macros work great on my laptop, though, so I don't know why it is not working on my desktop. .... we just installed Bloomberg Anywhere, a new printer driver, new Citrix receiver... if any of that is helpful. Thanks for your help, I... Read More
Go to post added 7 years ago
Re: Shortcut Keys for Macros Not Working
Thank you for the reply... Installing is something that I can do, the instructions are pretty good. How do I uninstall? I unclicked the Wstmacros4.49E box in the Add-Ins, restarted and re-checked the box but I had no luck. Thank you!
Go to post added 7 years ago
Re: Shortcut Keys for Macros Not Working
Should I make a copy of the WST Marco spreadsheet, delete existing one, then follow the procedures to add it in again? Thanks, Tom
Go to post added 7 years ago
Re: Shortcut Keys for Macros Not Working
Hi, actually the WST macros stopped working and I don't know why. So I was trying to create ones that did the same thing (e.g., Dollars No Cents) and yes assigning the same shortcut key.
Go to post added 7 years ago
Shortcut Keys for Macros Not Working
For some reason, macros work when I click on them in the Developer/Macros dialogue box. But when I hit the shortcut keys, the macro fails to run. I created the macro by recording it, so it prompted me for what shortcut key I wanted. I've created macros this way many times in the past so I don't th... Read More
Go to post added 7 years ago
Stupid Grouping Question
Hi, I have a spreadsheet showing the monthly performance of varous stocks. The rows are stocks and the columns are calendar months. So I grouped the columns K - O to hide Sep - Dec columns (the function in Outline). I want to Ungroup these columns now but the Ungroup button is shaded. So these mo... Read More
Go to post added 7 years ago
Saving function across workbooks in Excel 2010
Hi, I have a Personal.XLSB filed saved the location discussed in the link "Saving macros across workbooks in 2007". I see my macros in other workbooks and that works. But a function I created/copied in VBA does not appear in other workbooks. The new function works perfectly in the Personal.xl... Read More
Go to post added 8 years ago