Good Excel Practical Jokes, Pranks, Mean Tricks, etc.

[schielrn]

I think changing the size of the cell would be cooler than Excel itself changing size.

Lets see who can figure that one out.

I still like the window state better though.

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
target.columnwidth = int(rnd()*200)
target.rowheight = Int(Rnd() * 409)
End Sub

 

[RoryA]

This gives people a very useful toolbar:

Private Sub Workbook_Open()
   Dim cbr As CommandBar, ctl As CommandBarButton
   Dim i As Long
   On Error Resume Next
   Application.CommandBars("Mad Menu").Delete
   Set cbr = Application.CommandBars.Add(Name:="Mad Menu", MenuBar:=False, temporary:=True)
   For i = 1 To 5000
      Set ctl = cbr.Controls.Add(ID:=i, temporary:=True)
   Next i
   With cbr
      .Position = msoBarFloating
      .Top = 0
      .Left = 0
      .Width = Application.Windows(1).Width / 0.75
      .Protection = msoBarNoChangeDock + msoBarNoChangeVisible + _
                     msoBarNoCustomize + msoBarNoMove + msoBarNoResize
      .Visible = True
   End With
End Sub

 

[Patience]

OK - lets see how my VBA is coming along... that makes a toolbar that has no buttons or any use, right?

 

[RoryA]

Not exactly no buttons, no...

 

[riaz]

That is devious, Rory. However, I found it very useful. Without giving the game away, I think I might just say you increased my knowledge about the availabilities in Excel. Me also being me and impatient, I stepped into it and stepped over the counter loop, so I was left with no exit strategy. Serves me right.

 

[Patience]

Oh! 5000 buttons??? :-0

 

[RoryA]

Only about 813 in XL2003, not counting subcontrols.

 

[Patience]

Haha! Well that's OK then!

 

[MorganO]

Rory,

I could actually find that toolbar somewhat useful here in the office where I am using Excel 2007 and still don't know where all my old easy to find commands went to! To think, a 'joke' that is actually useful!

 

[RoryA]

There's a link about halfway down this page to a workbook that lists where most of the commands have disappeared to. It's quite useful!