You should never hide sensitive data in a workbook.
Data on Very Hidden sheets can be seen in seconds (point & click) with no special skills or crack software.
Am I allowed to say how?
How about something like this in your ThisWorkbook module?
Private Sub Workbook_SheetSelectionChange(ByVal Sh As Object, _
ByVal Target As Excel.Range)
If Sh.Name = "Sheet1" And Target.Column = 2 Then MsgBox "hello"
If Sh.Name = "Sheet2" And Target.Column = 4 Then MyModule_TheMacroDoingallthestuffIneed
I have been experiencing some paranormal activity in my email and U2U inboxes.
It's spooky. :stare:
Is it just me or is anyone else experiencing this phenomenon?
On the plus side it seems to have scared off Ngbugo Myguto from Nigeria.
Thanks Tom, I've been busy lately, and haven't had time to post - hopefully I can be more active here in the New Year. I'm off :bike: to Texas/Chihuahua for Christmas and it pains me to be offline for 3 weeks. Inlaws and no computer. Priceless.
Thanks Will, but I don't think I can mail him to you that quickly - especially with the post office's pre Christmas rush - the cutoff date for UK bound mail was Dec 8th.
U2U me a mailing address if you're interested.
I've received a paper doll cutout named "Eric" from a school deep-ina-heart-of-Texas. I'm to send the class a local photo of Eric along with a letter and/or postcard, then send Eric off to friend somewhere else on this big planet. The class will plot his progress and learn about different cultures and places.
Anybody interested in boarding this intrepid Texan(click for pic.) and showing him around town. He's a nice boy, I'm not sure if he :cheers: or :music: but maybe he'll let his hair down once he gets out of state.
To borrow a line overheard at a big fat Greek wedding…
The man is the head of the house but the wife is the shoulders and she can turn the head anyway she wants.
Originally posted by AUSSIECOMM
Hmmmmmmmmmm, certainly gives me, for one, a whole new perspective on Bill Gates!!!!! Not a bad sort after all.
It's ok Aussie/Will, you can go back to disliking Bill. He didn't write it. Snopes is my friend.
< snip >
This list is the work of Charles J. Sykes, author of the book Dumbing Down Our Kids: Why American Children Feel Good About Themselves But Can't Read, Write, Or Add. (The list has appeared in newspapers, although not necessarily in this book.) Many versions of this list omit the last three rules:
Rule No. 12: Smoking does not make you look cool. It makes you look moronic. Next time you're out cruising, watch an 11-year-old with a butt in his mouth. That's what you look like to anyone over 20. Ditto for "expressing yourself" with purple hair and/or pierced body parts.
Rule No. 13: You are not immortal. (See Rule No. 12.) If you are under the impression that living fast, dying young and leaving a beautiful corpse is romantic, you obviously haven't seen one of your peers at room temperature lately.
Rule No. 14: Enjoy this while you can. Sure parents are a pain, school's a bother, and life is depressing. But someday you'll realize how wonderful it was to be a kid. Maybe you should start now. You're welcome.
</ snip >
Like it says, it makes the site disappear. I'm in trouble now, I ruined it for everyone. sorry.
HAYNES MANUAL - THE REAL MEANINGS
For those of us that have ever used a Haynes Manual in attempting home
maintenance of a car. For those who have not used a Haynes Manual, these are
the books aimed at car-owners who want to fix their own cars and which keep
qualified mechanics in paid employment putting things right afterwards. They
are chock full of photos, diagrams and step-by-step instructions which are
obvious if you are a fully qualified motor mechanic, but which are
frighteningly sparse on detail for the average Joe in the street who wants
to change a set of spark plugs on a 1981 VW Polo ....
There is an interesting Excel quiz floating about the internet, identify the gifs (ie batman, beatles) and get a correct/wrong response.
It is on the http://www.flipflopflyin.com site which has been temporarily disabled due to a dramatic increase in downloads of this file.
It is also available here: http://www.siliconhell.com/mindbenders/minipops.xls
Who wants to be a Millionaire - Irish contestant
Chris Tarrant -
"OK Paddy. You have three life lines and you want to use one of them at this stage - which would you like to use?"
Paddy - "I'll phone a friend please Chris"
Chris Tarrant - "Who do you want to phone Paddy?"
Paddy - "I'll phone Tommy please Chris"
Tommy - "Hello"
Chris Tarrant - "Tommy??"
Tommy - "Yes"
Chris Tarrant - "It's Chris Tarrant on ITV's Who wants to be a Millionaire."
Tommy - "Christ"
Chris Tarrant - "I've Paddy here & he needs your help to get him to 2,000, the next voice you hear will be Paddy".....
Paddy - "Tommy, will I go 50/50 or should I ask the audience?"..........
Thanks guys, I'll try your solutions tomorrow .......... after coffee.
Ok, its my turn to ask a question.
When an Excel file is opened via the intranet or browser all controls, menus and macos work but the Window menu does not show.
Windows-Freeze Frames or Windows-Split canot be used.
The end-user prefers opening the file over the intranet. I think I could add a VBA freeze-frame button w/code that would work on the web and will test that out.
Does anyone have any insights, comments or non-code solution?
Yes, it is necessary, Its just a variable that Dave declared. "BisClosing" (book is closing true/false). He could just as easily called it "Hey_Man_I_am_Closing".
Hi D, and welcome to the Forum.
How about some code that saves the sum formula, clears the column, then replaces the formula?
You would have to name the cell (ie "test") using Insert-Name-Define that contained the formula that you want to save or just reference the cell address (ie B10)
z = Range("test").Formula
Range("test") = z
z = sheets("sheetname").Range("b10").Formula
sheets("sheetname").Range("b10") = z
Something screwy going on. I got logged out and couldn't get back in.
Whoa, you guys had C64s? All I had was a Sinclair ZX81 that wailed like a banshee when I stored or retreived programs from audio cassettes.
My first business computer was an ICL (British made in Japan?) running MPM (think networked CPM). We almost went for the 5mb disk but upgraded to 10mb even though the consultant said we'd never fill the 5mb. Our main app was a database called FMS-80. I was totally giddy when I saw my first spreadsheet and realized the possibilites.