Logo 
Search:

MS Office Answers

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Willie Howell   on Mar 04 In MS Office Category.

  
Question Answered By: Xavier Thompson   on Mar 04

Unless you are changing them on a regular basis, the cells  with the hours in
them don't need to be anywhere near the "H" cells or the formulas - they can
just as easily be on a different sheet.

In most instances, these hour values would be common either from day to day
or from week to week, and probably even from person to person. This would
mean that you don't need an hours value for every day anyway - you could
have all the formulas referring to a few common values.

However, I don't know your specific circumstances. If you want to keep this
information close to the other information, then that's fine, and you just
need to protect the cells at the same time as you hide  the rows.

Share: 

 

This Question has 13 more answer(s). View Complete Question Thread

 
Didn't find what you were looking for? Find more on How to run multiple procedure within Vba Or get search suggestion and latest updates.


Tagged: