Actuarial Outpost
 
Go Back   Actuarial Outpost > Actuarial Discussion Forum > Software & Technology
Reload this Page What's in your Personal.xls??
Register Blogs Wiki FAQ Calendar Search Today's Posts Mark Forums Read
FlashChat Actuarial Discussion Preliminary Exams CAS/SOA Exams Cyberchat Around the World Suggestions

Entry Level
Actuarial Jobs
Casualty, Health
Pensions
Life, Investments

DW Simpson & Co.
Actuarial
Recruitment
Worldwide

Casualty Jobs
& Property -- Worldwide
Reinsurance,
Insurance, Bureaus & Consulting

Salary Surveys
Life & Health
Pension
Property & Casualty


Reply
Page 7 of 10 < 1234567 8910 >
 
Thread Tools Display Modes
  #61  
Old 01-25-2010, 09:34 PM
Anonymouse
Guest
  
Posts: n/a
Default
Quote:
Originally Posted by carryme View Post
I think he was referring to CTRL+` which is the shortcut for alternating between showing values or formulas.

I think the confusion came from the fact that CTRL+~ is actually CTRL+SHIFT+`
yup
Reply With Quote
  #62  
Old 01-26-2010, 09:18 AM
ShakeNBakes's Avatar
ShakeNBakes ShakeNBakes is offline
Official AO Ninja
  
Join Date: May 2005
Location: you can't see me
Studying for my next eye exam
Favorite beer: Guinness - because it's color of ninjas. And delicious.
Posts: 14,575
Default
Quote:
Originally Posted by Anonymouse View Post
yup
Well, smarten up. If I mean Ctrl+Shift+a, I don't write it as Crtl+A. Bunch of giraffes on this forum.
Reply With Quote
  #63  
Old 01-27-2010, 10:25 AM
jvaldez84 jvaldez84 is offline
Member
  
Join Date: Feb 2007
Location: Houston, TX
Studying for C
College: Texas A&M Alumni
Posts: 1,053
Default
I created a Personal.xls in my XLStart folder. When I open a file it also opens the Personal.xls. How do I hide it so this file is not always showing on my toolbar everytime I open Excel?
__________________
P FM MFE MLC C
VEE Econ VEE Stat VEE Finance
Reply With Quote
  #64  
Old 01-27-2010, 10:27 AM
Abused Student's Avatar
Abused Student Abused Student is online now
Member
SOA 		 
Join Date: Feb 2007
Location: The Eighth Circle of Hell
Favorite beer: Cold and lots of it
Posts: 35,871
Default
Quote:
Originally Posted by jvaldez84 View Post
I created a Personal.xls in my XLStart folder. When I open a file it also opens the Personal.xls. How do I hide it so this file is not always showing on my toolbar everytime I open Excel?
Just hide the spreadsheet. It will still open but will be hidden.
__________________
GAME ON!!!!!!! Let your ness show. Join the D&D fun. Started but applications still accepted


Officially assigned the role of Dictator, 9/30/09. Bow to my whims.
Reply With Quote
  #65  
Old 01-27-2010, 10:30 AM
maryland maryland is offline
Member
SOA 		 
Join Date: Jan 2008
Location: Bmore
Studying for APM
Favorite beer: Breckenridge Vanilla Porter
Posts: 119
Default
Quote:
Originally Posted by Abused Student View Post
Just hide the spreadsheet. It will still open but will be hidden.
Is there anyway to not have to exit out of the Workbook and actual the Excel program when you have a personal.xlsb file or is that the minor disadvantage? I'm guessing I have to close out of Excel itself because the personal.xlsb, though hidden, is still open after I close out of another file.
Reply With Quote
  #66  
Old 01-27-2010, 10:30 AM
ShakeNBakes's Avatar
ShakeNBakes ShakeNBakes is offline
Official AO Ninja
  
Join Date: May 2005
Location: you can't see me
Studying for my next eye exam
Favorite beer: Guinness - because it's color of ninjas. And delicious.
Posts: 14,575
Default
I've got my personal.xls hidden. Is it any more efficient to have it saved as an add-in instead?
Reply With Quote
  #67  
Old 01-27-2010, 10:33 AM
jvaldez84 jvaldez84 is offline
Member
  
Join Date: Feb 2007
Location: Houston, TX
Studying for C
College: Texas A&M Alumni
Posts: 1,053
Default
Quote:
Originally Posted by Abused Student View Post
Just hide the spreadsheet. It will still open but will be hidden.
How do I do this? I get a message box saying that a workbook must contain one visible sheet.
__________________
P FM MFE MLC C
VEE Econ VEE Stat VEE Finance
Reply With Quote
  #68  
Old 01-27-2010, 10:34 AM
jvaldez84 jvaldez84 is offline
Member
  
Join Date: Feb 2007
Location: Houston, TX
Studying for C
College: Texas A&M Alumni
Posts: 1,053
Default
Quote:
Originally Posted by ShakeNBakes View Post
I've got my personal.xls hidden. Is it any more efficient to have it saved as an add-in instead?
I thought add-in's only consisted of UDF and not macros.
__________________
P FM MFE MLC C
VEE Econ VEE Stat VEE Finance
Reply With Quote
  #69  
Old 01-27-2010, 10:36 AM
ShakeNBakes's Avatar
ShakeNBakes ShakeNBakes is offline
Official AO Ninja
  
Join Date: May 2005
Location: you can't see me
Studying for my next eye exam
Favorite beer: Guinness - because it's color of ninjas. And delicious.
Posts: 14,575
Default
Quote:
Originally Posted by jvaldez84 View Post
How do I do this? I get a message box saying that a workbook must contain one visible sheet.
In the spreadsheet, Windows -> Hide. Make sure you save it on exit.
Reply With Quote
  #70  
Old 01-27-2010, 10:39 AM
jvaldez84 jvaldez84 is offline
Member
  
Join Date: Feb 2007
Location: Houston, TX
Studying for C
College: Texas A&M Alumni
Posts: 1,053
Default
Quote:
Originally Posted by ShakeNBakes View Post
In the spreadsheet, Windows -> Hide. Make sure you save it on exit.
Great! Thanks! I knew I was misinterpreting something.
__________________
P FM MFE MLC C
VEE Econ VEE Stat VEE Finance
Reply With Quote
Reply
Page 7 of 10 < 1234567 8910 >

Tags
macros, vba

« Previous Thread | Next Thread »
Thread Tools
Display Modes
Linear Mode Linear Mode

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


All times are GMT -4. The time now is 12:41 PM.

Contact Us - Actuarial Outpost - Archive - Privacy Statement - Top

Powered by vBulletin®
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.
*PLEASE NOTE: Posts are not checked for accuracy, and do not
represent the views of the Actuarial Outpost or its sponsors.
Page generated in 0.22076 seconds with 8 queries