Posts by h

Re: Automatically Change Font Size On Selection

thank you

Re: Automatically Change Font Size On Selection

Thanks for reply
but it did not work the way you suggest

when this line

Columns("C:D").Font.Size = 11

is excuted then the copying mode stops.................so I have to stop this line from excuting which I donot want to, but his is the only solution infront of me so far.......

any help on the point, pls............?

Hi there

I use this ok code to increase the font in the selected cell :

'Increase the Selected Cell Font


Private Sub Worksheet_SelectionChange(ByVal Target As Range)
    Dim TargetRange As Range
    Dim isect


    Set TargetRange = Range("C:D")
    Set isect = Intersect(Target, TargetRange)


    If Not isect Is Nothing Then
        Columns("C:D").Font.Size = 11
        Target.Font.Size = 15
        Exit Sub
    End If


    Columns("C:D").Font.Size = 11


End Sub

The problem is when i press ctrl+c to copy a cell content, so once i move the curser to the distenation cell then the copying mode in selected cell disappeared.

It is because when the event is trigered then the copying mode stops.

The question is : how to let the copying mode works even when the event is trigered ?

Hi there

Is there a code to open the Skype software ?

Re: Create Button in Excel Menu for Macro

yes, this is what i need. but inside Mymenu ?

Re: Create Button in Excel Menu for Macro

Thank you, but I need to know how to creat a toggle bottun inside this Menu, what the link shows is how to creat a macro inside menu.

any idea ?

Hello There

I am trying to make this code works by Toggle botten in Mymenu.
when i press the toggle bottun the copy takes place, then move the curser to distenation and press the Toggle again to past only the comment.

How to make the Toggle bottun inside Mymenu (A menu in the Worsheet Menu Bar).

Sub Macro1()
'    Selection.Copy
    Selection.PasteSpecial Paste:=xlPasteComments, Operation:=xlNone, _
        SkipBlanks:=False, Transpose:=False
    Application.CutCopyMode = False
End Sub

Re: Unload Add-in. Thisworkbook Is Currently Referenced By Another Workbook..

OK

by now I solved the problem.

I reregister the Excel, named the Excel to Excel.old and deleted all the registered Add-ins

Then my add-in worked well

Re: Unload Add-in. Thisworkbook Is Currently Referenced By Another Workbook..

Thank you for reply

I tried searching the MS, but ...................:sailboat:

I, surprisingly, note that when I open the Excel App the Add-in is loaded despit the fact that it is not checked in the Add-in window nor even listed inside the add-in window.

I.E. the add-in is not listed at all in the Add-in window and still loaded when the Excel App is opened. And the Add-in is not in the XLStart folder.

When open Excel App before it used to be open normally.
I think the problem that creat the msg is this

So, how can I make the Excel App open without my Add-in bing loaded ?[hr]*[/hr] Auto[hr]*[/hr] [b]Auto Merged Post Until 24 Hrs Passes;[dl]*[/dl]Ok, I solve the problem
My mistake was about saving the Add-in
I deleted all copies of my add-in and took my back up copy and save a copy of it in add-in folder. Then againg took a copy of it and save it in my folder.

now Excel opens normally without hte add-in bing loaded.
load and unload my add-in works fine.

however, after this the problem appears again ?????

Re: Unload Add-in. Thisworkbook Is Currently Referenced By Another Workbook..

I checked and it is not linked to another filea nor any file linked to the add-in

!!! i am surprice, it used to work fine

Re: Unload Add-in. Thisworkbook Is Currently Referenced By Another Workbook..

Thanks, Dave

OK

simply, the Addin has a command to insert a sheet in the opened workbook. This is to make some calculations and review some technical points. Then I delete the inserted sheet.

insert and delete sheet works fine. only when unloading the addin the msg appear.

Hello there

I try to unload my Addin, but i got this msg:

Thisworkbook is currently referenced by other workbook and can not be closed

Each time when i want to remove it from the main menue, I have to go to toolbars > customize and remove it.

before it used to be unloaded normally by unchecked the addin from the addin window.

could you tell how to solve this problem ?

Re: Controls OnAction Fails When Saved As Add-in .xla

Try and run the code line by line by pressing F8 to run the code each individually and tell me what is the msg you get

Re: Controls OnAction Fails When Saved As Add-in .xla

First chech that you cheked all the nessecary refrences in the vba window.

could you please emial me a copy of your WB to work it out

Re: Custom Toolbar .xlb File

Thanks for reply jhenderson

I use Excel 2003 and Windows vista op ?

I used search feature tring to find the .xlb file, but it does not show ?

Ok, got it , when opening and closing Excel app the .xlb file should be existed.

However, tried but not know where to find it :question::question::question:

please help

Hi there

I am tring to find the xlb file, but it does show in my laptop .

I open and close the xl App, but still could not find it

any idea how to creat one ? or where to find it in windows vista ?

:read:

Re: View Source Of Webpage

HI there

Interesting point

this code opens a web page for you

'*Open Web Page
Sub OpnWebPg()


'*Shows how to open websites using the FollowHyperlink method
    Dim strWebsite As String
    
 strWebsite = "http://www.ozgrid.com/forum/newthread.php?do=newthread&f=8"
     
'* Open the Web Page
    ActiveWorkbook.FollowHyperlink Address:=strWebsite, NewWindow:=True
     
End Sub

probably sombody ealse migh add more interesting points...............i will keep an eye

Re: Count If- Bank Reconciliation

you need to clarify what you need to do

Re: File Locked For Editing By 'User Name' On Save

Thanks Dave, this helps

Hello There

i have this code to run autofilter in protected sheet2, assigned to a check Box,
but it gives me this Msg when i run the code by checking the check Box :
File in use
The file is locked for editing by the (my name)

Any idea why is this ?

However, when i excute the code by F5 in the VBE window, it works fine
also when i excute the code from Worksheet_Activate , it works fine

here is the code:

Sub t()
With Sheet2
            .Protect "0", , , , userinterfaceonly:=True, Allowautofilter:=True
            .AutoFilterMode = False
            .Range("A5:DT5").AutoFilter
End With


End Sub