LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default VB Code for Excel

Hello,

I have 2 questions

1) I need help writing code wihin excel. I want to write code that
everytime I open the spreadsheet it takes me to the current date. For
example I have a workbook that I create every month that has multiple
sheets in it. Each sheet has the days of the month numbered as
follows 1, 2,3,4,5 etc. I want the sheet to open to the current day
when it opens. Example. if today is the 26th I want the sheet named
26 to be opened first. Excel by default will open to the last sheet
that was changed when the save was made. Please help.

2) Also, I would like to know how to hide a sheet within excel using
macros. The workbook has multiple sheets in it and I need a specific
sheet to always be hidden unless a specific user opens the workbook.
For example: if I open the workbook I want to be able to see the
sheet, but if another user opens the workbook the sheet will be hidden
but all other sheets will be visible. I'm not sure if it matters or
not but I need to give access to 4 users to be able to see this sheet
but all other users that open the workbook wont be able to see it.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Code to conditional format all black after date specified in code? wx4usa Excel Discussion (Misc queries) 3 December 26th 08 07:06 PM
Drop Down/List w/Code and Definition, only code entered when selec Spiritdancer Excel Worksheet Functions 2 November 2nd 07 03:57 AM
Convert a Number Code to a Text Code Traye Excel Discussion (Misc queries) 3 April 6th 07 09:54 PM
Unprotect Code Module in Code Damien Excel Discussion (Misc queries) 2 April 18th 06 03:10 PM
copying vba code to a standard code module 1vagrowr Excel Discussion (Misc queries) 2 November 23rd 05 04:00 PM


All times are GMT +1. The time now is 05:10 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"