View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Ram[_5_] Ram[_5_] is offline
external usenet poster
 
Posts: 42
Default Command button code(SC)

On Jun 10, 5:29 pm, FSt1 wrote:
opps. wrong thread
sorry
FSt1



"FSt1" wrote:
hi,
there is alot of freeware to crack passwords. excel security is not that good.
http://www.cpearson.com/excel/password.htm
http://www.mcgimpsey.com/excel/fileandvbapwords.html
http://www.nirsoft.net/utils/accesspv.html


go a google. you'll find more.


Regards
FSt1
"Ram" wrote:


Hi,


I have 4 madatory cells in my Excel sheet, and I have to design it in
such a way that if and only if these 4 cells are filled and on
clicking next button it should take us to the next page"Worksheet
name : nxt_pg". If any on the cell is Blank a msg box should appear
asking to Provide Details and on clicking OK it should activate the
cell that is left blank. All the 4 cells are named (R_nm, E-ml, Date,
Cntry).


Thanks for your help in advance


SC- Hide quoted text -


- Show quoted text -


Thanks a lot this works.. But instead of cell numbers I want to
declare specific names to be displayed in the message box as this code
returns a msg box that says "All of the cells H13, H14, H15, H16
should be completed". Is it Possible.