![[personal profile]](https://www.dreamwidth.org/img/silk/identity/user.png){kind=small}
nerd humor
Apr. 7th, 2004 05:04 pmi was searching the net to find the "before save" event in vba and i came across this great exchange on the usenet. (edited to protect the innocent, and to make it less geeky.)
from humble nerd:
I no the subject sounds strange. Here's what I want to do:
Disable the "save" and the "save as" functions
Any ideas...?
--------------------------------
from codegod:
Utilise the BEFORE_SAVE event
Simply enter
CODE
If Range("X")="" or range("Y") = "" or range("Z") = "" then cancel = true
where X,Y and Z are your range references
Rgds, codegod
--------------------------------
from: humblenerd
I tried this:
Cancel = True
And nothing.
I also tried creating:
Public Sub
Cancel = True
End Sub
And called this from the worksheet but nothing.
Basically I need to disable the save and save as features unless certain cells are completed.
--------------------------------
from: codegod
As I stated in the 1st line of my response
Quote:
Utilise the BEFORE_SAVE event
This needs to go in the WORKBOOK module
Double click on the Thisworkbook in the projects window in VBE
Choose "Workbook" from left side dropdown
Choose "Before Save" from the right side dropdown
Put the code in there
Rgds, codegod
-----------------
from: humblenerd
Think I might have painted myself into a corner here.
I've got that script working a treat - just one snag.
I can't save it.
from humble nerd:
I no the subject sounds strange. Here's what I want to do:
Disable the "save" and the "save as" functions
Any ideas...?
--------------------------------
from codegod:
Utilise the BEFORE_SAVE event
Simply enter
CODE
If Range("X")="" or range("Y") = "" or range("Z") = "" then cancel = true
where X,Y and Z are your range references
Rgds, codegod
--------------------------------
from: humblenerd
I tried this:
Cancel = True
And nothing.
I also tried creating:
Public Sub
Cancel = True
End Sub
And called this from the worksheet but nothing.
Basically I need to disable the save and save as features unless certain cells are completed.
--------------------------------
from: codegod
As I stated in the 1st line of my response
Quote:
Utilise the BEFORE_SAVE event
This needs to go in the WORKBOOK module
Double click on the Thisworkbook in the projects window in VBE
Choose "Workbook" from left side dropdown
Choose "Before Save" from the right side dropdown
Put the code in there
Rgds, codegod
-----------------
from: humblenerd
Think I might have painted myself into a corner here.
I've got that script working a treat - just one snag.
I can't save it.
the president and vice president are ordering lunch at a little organic bistro in DC. (They are there because Cheney has to watch his diet, and this place has the best salad in town.)
the veep orders his salad from the slightly granola-d-out waitress, and when she asks the pres what he'd like, he crooks his finger and says in a low voice:
"What i'd REALLY like is a quickie. I can't get one at home, hell, you've seen Laura, I doubt she knows what one IS."
The waitress looks at him and says "so THIS is a return to a moral center? you stinking hypocrite. i was RIGHT to vote for Nader." and she storms away.
Cheney leans over to Bush and says, "Sir I think that is pronounced 'Quiche' "
the veep orders his salad from the slightly granola-d-out waitress, and when she asks the pres what he'd like, he crooks his finger and says in a low voice:
"What i'd REALLY like is a quickie. I can't get one at home, hell, you've seen Laura, I doubt she knows what one IS."
The waitress looks at him and says "so THIS is a return to a moral center? you stinking hypocrite. i was RIGHT to vote for Nader." and she storms away.
Cheney leans over to Bush and says, "Sir I think that is pronounced 'Quiche' "
(no subject)
Dec. 27th, 2003 10:59 pmafter some careful crafting, i have developed the MOST blasphemous joke EVER.
Buddha, Jesus, and Brahman are walking to heaven:
Jesus: "Isn't there more than one way to heaven?"
Brahman: "Quit bugging me, I don't know everything."
Buddha: "I told you we should have purchased a map."
BONUS!: It isn't even FUNNY!
Buddha, Jesus, and Brahman are walking to heaven:
Jesus: "Isn't there more than one way to heaven?"
Brahman: "Quit bugging me, I don't know everything."
Buddha: "I told you we should have purchased a map."
BONUS!: It isn't even FUNNY!
a mean but funny joke
May. 10th, 2003 04:30 pmA woman was shopping at her local supermarket where she selected a quart of 2% milk, a carton of eggs, a quart of orange juice, a head of romaine lettuce, a 2 lb. can of coffee, and a 1 lb. package of bacon. As she was unloading her items on the conveyor belt to check out, a drunk standing behind her watched as she placed the items in
front of the cashier.
He said, "You must be single." The woman, a bit startled but intrigued by the derelict's intuition, looked at her six items on the belt. Seeing nothing particularly unusual about her selections she said, "Well, you know what, you're absolutely
correct. But how on earth did you know that?"
The drunk replied, "Cause you're ugly."
front of the cashier.
He said, "You must be single." The woman, a bit startled but intrigued by the derelict's intuition, looked at her six items on the belt. Seeing nothing particularly unusual about her selections she said, "Well, you know what, you're absolutely
correct. But how on earth did you know that?"
The drunk replied, "Cause you're ugly."
some fellows are sitting in a bar, when an old man decides he doesn't like the look of one of them, so he goes up to the young man, (who is just trying to drink his beer, ) and taps him on the shoulder.
"your grandmother is the best sex in town!" he shouts.
the young man looks uncomfortable, and attempts to ignore the old guy, who blinks waiting for a reaction. when he gets none, he stumbles back to his stool, and sits there, glowering for a few minutes, until he thinks of a new insult, when he thinks of one, he regroups and tries again, wandering over to the young man once more...
"i just had sex with your grandmother, and ohhh! it was sweeeet! what do you think of that?"
the young man says: "i think we should go home grandpa, you've had enough."
"your grandmother is the best sex in town!" he shouts.
the young man looks uncomfortable, and attempts to ignore the old guy, who blinks waiting for a reaction. when he gets none, he stumbles back to his stool, and sits there, glowering for a few minutes, until he thinks of a new insult, when he thinks of one, he regroups and tries again, wandering over to the young man once more...
"i just had sex with your grandmother, and ohhh! it was sweeeet! what do you think of that?"
the young man says: "i think we should go home grandpa, you've had enough."
