ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   macros 2007 (https://www.excelbanter.com/excel-programming/362667-macros-2007-a.html)

Rich Mcc

macros 2007
 
where do i find the macros option in 2007 !!!

regards
rich

Tom Ogilvy

macros 2007
 
See if it is on this developer ribbon:

XL-Dennis Says:
May 28th, 2006 at 10:24 am
To draw buttons on worksheets:
- Select the €˜Fat button in the left top corner of the main window
- Click on the Excel Options button
- Check the option Show developer tab in the Ribbon

Activate ATP & Solver
- In the same window as above choose Add-ins and
- Select Excel add-in in the Manage Combobox
- Click on the Go€¦ button

Kind regards,
Dennis

--
Regards,
Tom Ogilvy



"Rich Mcc" wrote:

where do i find the macros option in 2007 !!!

regards
rich


keepITcool

macros 2007
 
Hi Tom,

ATP functions are an integral part of excel 2007.

No need for the ATP addin... and it will refuse loading.
(it is only visible in the list as it is located in the \addins folder)

Plenty problems with the addin dialog itself...

If an addin is located in the (default) \Addins folder in the user
profile, it is parsed incorrectly and the OPEN statement is
progressively corrupted.

Workaround: copy addins for xl2007 to a separate folder
until this issue is resolved.

I've had REAL problems with corrupted registry entries
under HKCU\Software\Microsoft\Office\12.0\Excel\Add-in Manager

RegStudio Search (and Excel) found entries here.. BUT
RegEdit couldn't display them. (Similar to RootKit spoofing?)
Had do delete the Add-in Manager key to get rid of these hidden values.



--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


Tom Ogilvy wrote in


See if it is on this developer ribbon:

XL-Dennis Says:
May 28th, 2006 at 10:24 am
To draw buttons on worksheets:
- Select the €˜Fat button in the left top corner of the main
window - Click on the Excel Options button
- Check the option Show developer tab in the Ribbon

Activate ATP & Solver
- In the same window as above choose Add-ins and
- Select Excel add-in in the Manage Combobox
- Click on the Go€¦ button

Kind regards,
Dennis



All times are GMT +1. The time now is 12:11 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com