A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Personal.xlsm



 
 
Thread Tools Display Modes
  #11  
Old November 11th, 2009, 01:59 AM posted to microsoft.public.excel.misc
Dave Peterson
external usenet poster
 
Posts: 19,791
Default Personal.xlsm

Right now, I spend most of my excel time in xl2003. I would imagine that when
more and more people start using xl2007 (or greater), I'll have to learn more
and more about modifying the ribbon.

As long as your site is there, Ron, I'll have a place to start!

Ron de Bruin wrote:

Ron's gonna be mad at both of us!

You guys are smart.
I like problems g , sometimes I think about the good and fast Excel 2000.

But I really like this easy way for 2007
http://www.rondebruin.nl/qat.htm

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm

"Dave Peterson" wrote in message ...
Now you've done it.

Ron's gonna be mad at both of us!

Gord Dibben wrote:

Welcome to the sloth club.

MyMacros.xla works fine for both 2003 and 2007

I have added a few buttons to QAT but that's as far as I go.

Gord

On Tue, 10 Nov 2009 11:49:11 -0600, Dave Peterson
wrote:

I use the same personal.xla (an addin) on both xl2007 and xl2003. I don't save
the addin as .xlam for xl2007.

The both work fine in both environments.

I've been lazy and haven't changed my toolbar/worksheet menu modifications to
use the ribbon, but that's ok with me.


--

Dave Peterson


--

Dave Peterson
  #12  
Old November 11th, 2009, 03:20 PM posted to microsoft.public.excel.misc
Andy
external usenet poster
 
Posts: 941
Default Personal.xlsm

Thanks so much! You are so helpful!

"Ron de Bruin" wrote:

Hi Andy

Rename it with another extension will not work
I assume your personal.xlsm is hidden

On the View tab in the window group choose UnHide
Then do a save as xlsb
On the View tab in the window group choose Hide

Then close Excel and say Yes to save the changes to your PERSONAL file.


You can find the correct location on this page
http://www.rondebruin.nl/personal.htm


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Andy" wrote in message ...
Several people at my company have a personal.xlsm file that stores their
Excel 2007 personal macros. My understanding is that the correct name should
be personal.xlsb. They seem to work fine. I'm not sure how this happened,
perhaps when they tried to convert them from personal.xls?

My first question is: should I change the filenames from personal.xlsm to
personal.xlsb or leave them alone? And if I should change them, should I
just rename them outside of Excel?

Thanks for any suggestions.

.

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 03:45 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.