Search results for query: *

Thank you.

Thank you for your reply. I added a user form and got it to load when the workbook opens; however this keeps the user from accessing the sheet while the menu is open. Is there a way around this with out haveing to close and reopen the menu everytime?

I have googled and searched Tek-Tips and can not find the answer so I thought I would post my question. I created a menu in Excel with shapes and I need the menu not to move either vertically or horizontally when the user sctolls. To complicate things I have a header row that is frozoen as well...

Thank you for your replies, The user used buttons/sliders/combo boxes to select the data for the chart. That is how they move around the chart. I have found a solution. I set a universal range variable to a default then update it when something changes that default.

The Chart can change either by a single row or many rows and columns at once. It depends on how the user moves around the chart.

I created a dynamic chart and need to know the range of that chart when a button is clicked so I can reset the chart to that same range later on.

Does anyone know how to get the range of the Source Data of a chart in Excel using VBA?

While I understand this is a common issue and have searched for a while before my initial post; not only here but across the net; I have not found anything that is related to my specific issue. I can open it without issues outside Citrix but get this error when I try and open it in Citrix.

I have an Excel 2007 document that opens fine when I open it with a local copy of my Excel. When I try and open the same document from the same location with Citrix I get the Excel found unreadable content in myexcel.xlsm... I click yes and get no more errors; but I do not like this message. Has...

Thank you both this solved my issue.

I have a worksheet with a group of hidden rows and the are locked. If the user hits the down arrow it skips past these ok but if they hit the enter key the curser moves to these hidden rows. Is there a way to make the enter key act like the down arrow?

I cannot believe I missed this... It was on the worksheet change event; the code changes the event = endless loop! Thank you for all your help this was just a boneheaded mistake and I did not even think it all the way through.

Thank you for your post. I tried it and I still am getting the same error.

it fails on the first output line OutputRange.Item(1, 1).Value = InputRange.Item(1, 2).Value

When I run the following code I get an Object variable or With block variable not set error and can not figure out why any helpl would be appriciated. Dim InputRange As Range Dim OutputRange As Range Set InputRange = Sheets("Misc").Range("A18:E18") Set OutputRange =...

Hi All, I need to see if a cell is referanced in a range... ie Cell G32 could be in A1:L50 or G1:G60 of Sheet2 B20:H40. Is there an easy to find these referances vs the trace dependents?

Thank you myListView.ColumnHeaders(0).Width = 0 worked.

I have a ListView that is built dynamically and need to hide the last column. Is there a way to do this? I am using Excel 2007.

I have a field that I need to sort on. That field that could be a number or text. It currently sorts numbers as 1 10 2 3 30 31 32 4 5 6 7... I need them to sort 1 2 3 4 5 6 7 8 9 10 11 etc... Is there a way to do this with a regular expression? Such as adding x number of spaces to the number...

Code correction: While Not myRecordSet.EOF nameRange.offSet(nextR, 0) = myRecordSet(0).Value myRecordSet.Move (1) nextR = nextR + 1 Wend