"Changing the colour of the Tab" when runing this in macro i get thhis error " Compile error" "only comments may appear after End Sub, End Function, or end Property"
Thanks in advance
P

Edited by author 05-22-2008 05:53 PM
Ivan, when I try to download the menumaker_UF_API.zip, I am brought to a sponsor screen, but no download. How do I get this incredible code?

I used to be able to enter the date with just the month and day, the year would fill automatically (to current year) unless I typed in a different year to over-ride it. Now if I type "Jan 1" the program assumes that it is Jan 1, 2001. I've tried all the setting I can find - no luck. Help!

Edited by author 05-05-2008 12:16 PM
Can someone please tell me how to use the Disable Cut, Copy & paste macro for one column only? I need to use it for column A on my worksheet called "Pool Attainment Report 1."

Option Explicit


Sub DisableCopyCutAndPaste()
    EnableControl 21, False ' cut
    EnableControl 19, False ' copy
    EnableControl 22, False ' paste
    EnableControl 755, False ' pastespecial
    Application.OnKey "^c", "Dummy"
    Application.OnKey "^v", "Dummy"
    Application.OnKey "+{DEL}", "Dummy"
    Application.OnKey "+{INSERT}", "Dummy"
    Application.CellDragAndDrop = False
    Application.OnDoubleClick = "Dummy"
    CommandBars("ToolBar List").Enabled = False
End Sub

Sub EnableCopyCutAndPaste()
    EnableControl 21, True ' cut
    EnableControl 19, True ' copy
    EnableControl 22, True ' paste
    EnableControl 755, True ' pastespecial
    Application.OnKey "^c"
    Application.OnKey "^v"
    Application.OnKey "+{DEL}"
    Application.OnKey "+{INSERT}"
    Application.CellDragAndDrop = True
    Application.OnDoubleClick = ""
    CommandBars("ToolBar List").Enabled = True
End Sub

Sub EnableControl(Id As Integer, Enabled As Boolean)
Dim CB As CommandBar
Dim C As CommandBarControl
  
On Error Resume Next
For Each CB In Application.CommandBars
    Set C = CB.FindControl(Id:=Id, recursive:=True)
    If Not C Is Nothing Then C.Enabled = Enabled
Next

End Sub

Sub Dummy()
    '// NoGo
    MsgBox "Sorry command not Available!"
End Sub

Edited by author 04-23-2008 09:00 PM
I am trying to use excel to track a list of tasks that require a certain amount of time to complete. I would like to total the h:mm:ss to days, h:mm. Can tht be done? If so how do I format the cells and configure the formula?
Please reply to: themanroom@vcn.com

Hi Ivan,

First of all, my congratulations on your impressive site ... and your in-depth knowledge ...
In your opinion, is there a way to hook the Excel spinbutton control (FM20.dll)... In order to visually help users, I wish I could end up with different colors for each arrowhead ...
Thanks in advance for your comments

Rose
If you are inserting the images as a link they will not show up.
How exactly are you inserting the images?

I am using Excel 2003. I have created a brochure with images I want to send to clients but the images disappear when they get it, how do I embed images or send it so they can see the pictures in this excel sheet??

Thank you. This is the first time I'm using WMI event notification from Excel.

urkec, the performance hit I speak of was if running "my" code from pure vba, i.e using Do Loop and DoEvents ..... YOUR code in a Clas module should work OK.

Recently I ran into your post named 'Monitor Directory' from 7th July 2006 on 'Daily Dose of Excel' that shows how to monitor a directory for file system changes. You use VBScript because there is 'a performance hit' when converting the code to VBA. I need this functionality, so I put together some code that uses Excel VBA rather than VBScript. I haven't noticed any performance degradation in comparison to VBSCript code, but am still reluctant to use this in a production environment. So, please explain in more datail what were the difficulties that you ran into when using WMI event notification in VBA. ( posted a question here, but received no comments yet:
http://groups.google.com/group/microsoft.p...ad/40ebcfecbffa9900# )

Thanks in advance.

I have a custom excel workbook with a macro that changes the background image of a specific sheet, I want to add a built-in theme selector which changes the background of a sheet by using images or objects stored witin the workbook itself. Is there a way to set a background image of a sheet from an existing object image embedded within the workbook or sheet itself?

Tom

Which page is that on. I am having problems with my Downloader + I have been away with personal problems to tend to so I have not paid much attention to my site.

Hello, I like to download your Animated gif using an OCX. But when I click on it it takes me to this site ??
 http://wwwz.websearch.verizon.net/search?q...&rn=e88YFYVgot60kxr

It does not let me download the oxc

Is there any other way to do this.

Regards, Tom