need help on excel

4 posts

Please Login or Signup to reply.

rainhawk87

342 posts since Aug '05
- 12 Mar `08, 11:01PM
  
  how do i write on vba when
  
  1st i need to verify there is text on the highlighted boxes before closing and saving the excel.
  
  2nd, how do i only allow step 1 to step 10 in order without allowing user to skip any step in advance.
  
  anyone able to help me?
  
  thank you
caleb_chiang

6,736 posts since Jul '05
- 13 Mar `08, 12:44AM
  
  vba? hmm... lost touch...
ceecookie

9,528 posts since May '04
- 13 Mar `08, 12:45AM
  
  Originally posted by caleb_chiang:
  
  vba? hmm... lost touch...
rainhawk87

342 posts since Aug '05
- 15 Mar `08, 9:48PM
  
  how to lock excel so that you are unable to "save" and "save as" just able to open and read only then print.
  
  thank alot

Please Login or Signup to reply.

Shoutbox
- <sbst275>
  - Profile
  - 09 Jul `08, 2:57PM
  NE*
- <Master -_->
  - Profile
  - 09 Jul `08, 2:57PM
  today bad mood
- <sinicker>
  - Profile
  - 09 Jul `08, 2:58PM
  yes. the tong tar premium is frm jurong east.
- <sbst275>
  - Profile
  - 09 Jul `08, 2:58PM
  I mean basic sv la
- <sinicker>
  - Profile
  - 09 Jul `08, 2:58PM
  but only good for residents there lah. no need to switch switch.
- <sbst275>
  - Profile
  - 09 Jul `08, 2:58PM
  but dunno la, plan liao... if you can get no of drivers ok fine and well
- <sinicker>
  - Profile
  - 09 Jul `08, 2:59PM
  i wouldnt even think PTC would allow it. haha. want everyone cram inside the train.
- <Master -_->
  - Profile
  - 09 Jul `08, 2:59PM
  cannot carpool meh
- <Master -_->
  - Profile
  - 09 Jul `08, 2:59PM
  or get a hostel zz
- <sinicker>
  - Profile
  - 09 Jul `08, 2:59PM
  oh.. they wudnt say cram inside.. they wud say "optimise capacity"
- <sinicker>
  - Profile
  - 09 Jul `08, 3:00PM
  carpool... with today's oil prices & erp, it's hard to break even.
- <sinicker>
  - Profile
  - 09 Jul `08, 3:00PM
  hostel dont want. the place so ulu. even if i cook there, i'm only wasting studying time.
- <sbst275>
  - Profile
  - 09 Jul `08, 3:01PM
  dun think so if they want to get ppl to take public tpt
- <sbst275>
  - Profile
  - 09 Jul `08, 3:01PM
  anyway there's alrdy push factor other than pull factor
- <sbst275>
  - Profile
  - 09 Jul `08, 3:01PM
  coming RSAF Open Hse better have no more public bus mess
- <sinicker>
  - Profile
  - 09 Jul `08, 3:02PM
  if carpool, how much per person?
- <sinicker>
  - Profile
  - 09 Jul `08, 3:02PM
  tamp > ntu. one way trip how much!? u people be my private transport council.
- <sbst275>
  - Profile
  - 09 Jul `08, 3:03PM
  carpool I've no idea.. but such dist + parking it's going to cost a lot
- <sinicker>
  - Profile
  - 09 Jul `08, 3:05PM
  yes. parking is capped at $3. distance is +-80km. so that's 8L of petrol.
- <sinicker>
  - Profile
  - 09 Jul `08, 3:06PM
  ERP is 50cents 0730-0800.
- <sinicker>
  - Profile
  - 09 Jul `08, 3:08PM
  ERP is 50cents 0730-0800.
- <sinicker>
  - Profile
  - 09 Jul `08, 3:08PM
  $1 0800-0830.
- <sinicker>
  - Profile
  - 09 Jul `08, 3:08PM
  & govt say wanna build one more ERP gantry just before eunos, westbound??
- <sinicker>
  - Profile
  - 09 Jul `08, 3:08PM
  stupid govt, ERP will never work u idiots!
- <sinicker>
  - Profile
  - 09 Jul `08, 3:09PM
  hope they're surfing sgforums now. hehe. lol.
- <sbst275>
  - Profile
  - 09 Jul `08, 3:23PM
  dun forget, one ever said ERP help ppl to own cars
- <Palmuser alan>
  - Profile
  - 09 Jul `08, 3:34PM
  Just iincrease the COEs to $100,000 and cars will disappear from the raods, all will take public transport. No need stupid ERPs. No need scholars from LTA to come with all kinds of stupid schemes. So simple!
- <Master -_->
  - Profile
  - 09 Jul `08, 3:44PM
  where got 80km
- <Master -_->
  - Profile
  - 09 Jul `08, 3:45PM
  zzz
- <sinicker>
  - Profile
  - 09 Jul `08, 3:59PM
  is 80km, or even more. PIE isnt that all straight. go home via KJE, BKE, SLE, TPE. faster.
Refresh

Singapore's Online Community

need help on excel

Shoutbox

Links

Latest Posts