Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 5
Default Button to Reveal Hidden Calculation?

I have another question regarding a timecard that I created for the company I
work for:

My boss has requested that the timecard have an efficiency ratio of Billable
Time to Non-Billable time. My idea was to create a button that could be
password protected that would reveal the efficiency rating or something like
that??? Has anyone done anything like this or similar that I could try to
impliment into my timecard?

Thanks!

Joe
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default Button to Reveal Hidden Calculation?

Why not just put the calculation in a column of cells and then hide that column.

But be aware that your results will be able to be seen--even if you protect the
worksheet. Excel's protection isn't made to stop this kind of stuff.



jcolley05 wrote:

I have another question regarding a timecard that I created for the company I
work for:

My boss has requested that the timecard have an efficiency ratio of Billable
Time to Non-Billable time. My idea was to create a button that could be
password protected that would reveal the efficiency rating or something like
that??? Has anyone done anything like this or similar that I could try to
impliment into my timecard?

Thanks!

Joe


--

Dave Peterson
Reply
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
How do i reveal hidden sheets surreyjed Excel Discussion (Misc queries) 3 September 4th 06 06:50 PM
How can I reveal hidden column and row headings on screen? Caroline E Excel Discussion (Misc queries) 3 March 10th 06 12:04 PM
Drop down list button hidden Cathy Landry Excel Worksheet Functions 3 August 25th 05 06:21 PM
Ho do I reveal the hidden format codes? box Excel Worksheet Functions 1 March 23rd 05 12:08 AM
Hidden button on Taskbar tubroh730 Excel Discussion (Misc queries) 4 December 23rd 04 03:23 AM


All times are GMT +1. The time now is 05:51 AM.

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"