Tracking Forums, Newsgroups, Maling Lists
Home Scripts Tutorials Tracker Forums
  Advanced Search
  HOME    TRACKER    Excel


Advertisements:










Hyperlinks :: This Operation Has Been Canceled Due To Restrictions In Effect On This Computer


while trying to view a hyperlink i just created in a cell within a worksheet, a message popped up saying:

mircosoft office excell:

X this operation has been canceled due to restrictions in effect on this computer. Please contact your system administrator.


View Complete Thread with Replies

Sponsored Links:

Related Forum Messages:
Due Dates To Days Past Due
I am trying to create a spread sheet in excel that will show a number of days past due counting from the due dates. see the attached xls file for details.

View Replies!   View Related
2 Lists And Finding New And Canceled Data Through VBA
I have 2 sets lists which should be identical, but every day I get give one new file which I have to compare to the other one. I need to find new data and removed data in the new file.

It is a dynamic list, but I need to check every day that all the data that was there yesterday is also there today. If not then I need to be told which data is missing and which data is new (maybe thrrough a pop up box and a new sheet with a new and cnacles coloumn).

A Example of the data is below. On day1 everything matches. On day 2 Grapes is a new entry, so I need this flagged up.
On day 3, pears hsave disappeared, I need this flagged up.

What would be great is to have a messgae box pop up and say "2 new entiries and 3 deletions - Please refer top Changes tab". And then the new/deleted entries will be in a seperate sheet.

I have tried searching this on the site, but can't find anything (I can't beleive problem like this is not on the website) - If there is an article would you be able to point me to it.


Day1
orangeapple
pearorange
applepear
bananabanana

Day2
orangeapple
pearorange
applepear
bananabanana
grapes

Day3
orangeapple
pearorange
applebanana
bananagrapes
grapes

View Replies!   View Related
Protect Some Cells Without Other Restrictions
how do i protect a cell from being changed? I don't want to protect the whole worksheet, just a few cells within a worksheet? I have tried the Allow Range Users function, but cannot get it to work? Kind regards, Michele

View Replies!   View Related
Input Box Instructions/restrictions For Filtering Data
Is there a way that I add instructions/restrictions to the push buttons on my form (basically they perform filter functions).
For instance, currently the only way to search the client or employee name is to enter the entire name. Is there a way to allow partial name searches?

Can I have a message appear that says "'Joe Shmo' can not be found".

Also I would like the input box not allow blank searches. If the input box is selected but then closed with no data entered, it filters for blanks which removes all data.

I have attached a sample of my form for you to look at.


View Replies!   View Related
Explicit Hyperlinks, Relative Hyperlinks
I have a spreadsheet and within the first sheet there are lots of hyperlinks to other cells within sheet 1 (my template).

I have made a small macro which very basically makes a copy of sheet 1 (my template)

The hyperlinks in the template are explicit and as they are copied to sheet two, they still reference back to cells in sheet 1. I need the hyperlinks to be relative, so that when I make a copy of the template the hyperlinks are copied and make reference to cells in the new sheet. I cannot work out how this should be done

View Replies!   View Related
Algorithm For Addition (operation For Each ID)
Have an excel table with following data:
- ID
- number of bottles
- number of bottle crates (there are 20 bottles in one one bottle crate)

201688194000bottles
20168819200crates
2016883812000bottles
20168838600crates
201688396400bottles
20168839320crates
201688809000bottles
20168880600bottles
20168880480crates...................

I need to write a macro which will do this operation for each ID:

(bottles/20)-crates = x

and if "x" is not 0 then write down the value of "x".

There are two points I would like to point out:
- One ID may contain 3 or more rows (see 20168880)
- The macro will work with hundreds IDs so the algorithm should be fast (but it is not necessary)

View Replies!   View Related
Data - Text To Columns Operation
I have an issue with the Data - Text to Columns operation.

I paste some data into a sheet that is comma delimeted. I have a macro that runs the Data - Text to Columns operation and then moves the data to another sheet.(The data I need to paste is coming from a non-Excel application.)

I then copy a second set of data to another sheet and when I paste it, it automatically does the Data - Text to Columns operation but I do not want it to. I have seen this several times before and when I am manually manipulating the data it isn't a problem. When I use macros to manipulate the data, I don't get the desired results because my macro includes this operation.

I have done a little testing and this issue doesn't seem to always present itself. How can I paste the data without Excel trying to out-think me and just leave the data in the comma delimeted format it is in when I paste? What causes this? Its seems like Excel is seeing similar data and "assuming" I want to perform the same operation I just performed.

View Replies!   View Related
Carousel Effect
I would like to produce a carousel effect. i will start with a basic example and then explain the complications.

Basically I have a range of cells of indeterminant length. The left column is numbered vertically - let's say 1,2,3,4,5,6. I would like to be able to generate a carousel effect so that if I right click on a number all the cells below move down and the number at the bottom fills the gap so that if I right click on 1 the cells would become 6,1,2,3,4,5 or if I right click on 3 the cells would become 1,2,6,3,4,5.

The complication is that there will be more than one of each number eg 1,1,1,1,2,2,2,2,3,3,3,3,4,4,4,4,5,5,5,5,6,6,6,6. (there will allways be the same number of each) so I would want the whole block to move down and the ones at the bottom to come up and fill the gap.

The other slight complication is that the range of cells is 5 columns wide so I would want the whole block of cells to carousel.


View Replies!   View Related
Cost Average Effect
Example number 1:
You invested 10.000 Dollar in the year 1985 into a tempelton fund and waited 20 years. Result can be seen at many forums and stock plattforms

Example number 2:
In 1985 you had no 10.000 Dollar, but only 100 Dollar a month. You invested this 100 Dollar each month for 20 years.

How big will the difference be between example 1 and 2 ?

*** Background.
If a "share" will cost 100 Dollar, you will get 1 share for 100 Dollar. Next month share is down to 50 Dollar, you will get 2 shares for your monthly 100 Dollar. Next month share is up at 200 Dollar, you will get only a half share for your 100 Dollar. Its called cost average effect.

Tool should allow "play arround", to simulate various scenarios, talking into account growth rate, time period, monthly investment, fluctuation of a theoretical share. Idealy we would love to " import" e.g. famous fund history (eg. Tempelton, Pioneer) etc. to see how investment would have developed when a steady monthly payment would have been made.

View Replies!   View Related
Do Operation On All Sheets Except The First Sheet In The Book Every Time I Update It
I have a workbook that I would like the same operation on all sheets except the first sheet in the book every time I update it (which is once a week).

I get data (currency format) for all of my employees on a weekly basis. Unfortunately this data is shown as a negative number and I need to invert these values. (So I use the formula below)... but I have to do this manually for about 35 sheets and I figure I could automate this somehow with a macro. Here's what I do usually and what I would like the macro to do automatically:


I want to insert a column after column G.
I would like to enter the following formula into H2:

=IF(G4="u", "u", IF(G4

View Replies!   View Related
Error :: 'operation Is Not Allowed When The Object Is Closed
I keep getting an error in this code while trying to write the results of a query to a sheet in the current workbook. The error i get is 'operation is not allowed when the object is closed'... since i didnt close the recordset before trying to write the results to the worksheet, im at a loss to explain why im erroring...


Public Sub fillWorksheetWithData(dataSheet As Worksheet, conStr As String, sqlStr As String)
'clear datasheet
LastRow = dataSheet.Range("A65536").End(xlUp).Row
If (LastRow < 2) Then
LastRow = 2
End If
dataSheet.Range("A2:A" & LastRow).EntireRow.ClearContents

View Replies!   View Related
Hide Workbook Opening/closing Operation On The Screen
I am running a script that populates about 70 or so workbooks based on information from the database. Naturally this script is quite slow but what seems to take the most time is opening and closing workbooks. Is there a way to "hide" the workbook opening/closing operation on the screen? I have tried using the

Application. ScreenUpdating = False

this sped the code up but you still see the workbooks opening on the screen.

View Replies!   View Related
Do Piviot Table Effect VB Code?
I created a couple of piviot tables from the same sheet I had VB code in. Since the creation of these P tables the code has stopped functioning.
In a attempt to re-activate the code i moved the piviots to a new spreadsheet. But the code is still not working....


View Replies!   View Related
Formula: Desired Effect Is Under Column 3
Not sure what formula to use for this set-up:

Col1 - Name_Last
Col2 - Name_First
Col3 - Ref_Name

The desired effect is under column 3, you have "Name_First Name_Last". Attached sample file.

View Replies!   View Related
Invert The Effect Of Freeze Panes
I would like to freeze the bottom part of my spreadsheet, such that the user can scroll through the upper part but still be able to see the bottom part. The freeze command freezes what is above the line, I want to freeze what is below the line.

View Replies!   View Related
Keydown To Effect To All Controls That Support Event
Is there a way to fix a private sub to catch keydown effect of various combos and textboxes of my userform?

Instead of typing the same thing to each and every control's keydown event just call a sub. Code goes like:

Select Case KeyCode
Case 112
ShellExecute 0, "open", "hh.exe", ThisWorkbook.Path & "1.chm", "", 1
Case 113
If MsgBox("Backup now", vbQuestion + vbYesNo) = vbYes Then BackUp
Case 114
Col = 3
SearchD
Case 115
showexcel
Case 116
readonly
e.c.t.

Instead of that, if i place code in a private sub test() just call test in keydown event

View Replies!   View Related
Macro To Effect Cell Based On Column
I wasnt sure how to name this problem, but here goes.

View Replies!   View Related
Charts: Vary Colors By Point With Area Fill Effect
I am attempting to create simple charts to show survey results 2005 v 2006. I have a single series in a bar chart - chart type. The wizard initially makes both bars the same fill color. I right-clicked one of the bars to start the Format Data Series Wizard. On the 5th tab, "Options", I ticked "Vary Colors By Point". A new color was assigned to the top or first bar. So far so good. But instead of these colors, I would like to use a different fill effect for each data point in the series

So I walk through the wizard and desiqn a fill effect and click ok. The fill effect is assigned to both data points. I checked where I had ticked "Vary Colors By Point"
It is still ticked. Can I override this somehow so that each data point can have a unique fill effect?

View Replies!   View Related
Loop: Macro To Go Through The Table And Preform An Operation In The Corresponding Cell In Column B Depending On The Value In Cell A
I have 2 columns and 10 rows (A1:B10). In column A are certain text values. How do I write a macro to go through the table and preform an operation in the corresponding cell in column B depending on the value in cell A? for example, if A3 = "Complete", overwrite the formula in B3 with the value (paste value)?

View Replies!   View Related
Fundamental Operation ("Compile Error, Invalid Use Of Property.")
It seems so basic that I hate to ask, but I cannot figure out why this doesn't work. The subroutine is in ThisWorkbook. I keep getting: "Compile Error, Invalid use of Property."

View Replies!   View Related
Calculate At All If Any Condition Within An "and" Operation Is Blank
How do I get a formula to not calculate at all if any condition within an "and" operation is blank?

View Replies!   View Related
Get Computer ID
Is there a code available that can be used to get the user's computer ID number (Not Computer Name)? I'm using a password generator to randomly generate a password and I would like to use this unique password with the user's Computer ID.

View Replies!   View Related
Figure Out How To Do An If For The Over 30,60,90 Past Due
Here is what my table is im working with. The tite "todays date starts in Cell A1 and B1 is =Today().

I need to figure out how to do an if for the over 30,60,90 past due. Here the logic I need to figure out:

in the Over 30 column, the logic of the statement is as follows: If the difference between today's date and the date of the invoice is greater than 30 and equal to or less than 60, the amount goes into this column.(over 30 E3) To get the amount(the ammount in C3) into the Current column, the difference between the two dates must be less than 30. To get into the over 90 column, the difference between the two dates must be greater than 90. You can figure out the over sixty column. And this needs to be copied to the remaining colums

Today’s date: =TODAY() Shop Invoice Date Invoice Amount Current Over 30 Over 60 Over 90 Ludwig's Landromat =TODAY()-72 $432.78 Willie's Washing =TODAY()-107 $565.11 Wash It Here =TODAY()-80 $308.47 Spiffy Wash and Dry =TODAY()-58 $725.37 Water Soap & Hot Air =TODAY()-30 $427.95 Wash it & Dry it =TODAY()-90 $603.91 Acme Wash & Dry =TODAY()-60 $332.35 Totals

View Replies!   View Related
Filtering The Due Dates
I have a simple excel sheet and two of the columns show a Due Date and a Received Date. All I want to do is highlight any cell in the Received Date column where the Received Date is greater than the Due Date. The spreadsheet shows Purchase Orders and shows when they were due to be received and when they actually were received. i'd like to be able to show all orders that were received past their due date.


View Replies!   View Related
Reminder For Over Due Dates
I have a task follow-up sheet that I have made for my manager, where I need I have a column to set the date when the item is entered or the date the item was discussed in meeting, etc. Then I have an additional column with "due date", here I select the date that the task needs to be completed or the date when I should be getting feedback.

What I would like is to have a pop-up that opens and tells me which tasks are due today. This could happen as perhaps a check everytime that I open my Excel file.

I realize that a conditional formatting can be used, to change the color and highligh items that are due, but I really want a pop-up, this will really make my life easier and communication to my manager easier as well. Plus my manager could use this file without me present. Allowing for less meetings to discuss list.

I have uploaded the sheet that I have so far.

View Replies!   View Related
Assign Computer ID
Does anyone have a macro that could assign a 16-digit number, seperated by dashes, to a computer? (i.e. Computer ID: xxxx-xxxx-xxxx-xxxx)

View Replies!   View Related
Return The Name Of Computer
Is there any way to return the name of the computer in Excel using VB?


View Replies!   View Related
Computer IP Address
I have a problem running an excel macro on different laptops because the IP needs to be known (my program links to databases that are installed on a "server" laptop). The IP can be sourced by using the "Start, Run, cmd, ipconfig" but my users can have problems with process.

Does anyone know of a vb function that will display the ip of the computer that the code is run on?

View Replies!   View Related
Formula To Get The Name Of My Computer?
Is there a code or formula to get the name of my Computer?

View Replies!   View Related
Overflow On One Computer But Not On The Other
i am experiencing runtime error '6': overflow on one computer but not on another computer when it is the exact same file running on two different computers.


View Replies!   View Related
Macro To Get Computer ID
a macro to get the computer ID of the computer where the excel file is opened?

View Replies!   View Related
If Functions And Date :: When Something Is Past Due
I am trying to create a function that will tell me when something is past due.

I have a excel document for my office's accounts payable, it has a master sheet where all of the companies that we pay are listed, and they are linked so that you can click on the name and it will take you right to the page to see a more detailed breakdown.

I am trying to figure out how to make something on the master page to tell me when something is due, even if it just makes an X when it is past due.

There are about 73 worksheets in this document and each worksheet contains many dates.

Is this even possible for me to do something like this? If not does anyone have any suggestions?

View Replies!   View Related
Flag Past Due Dates
to set a conditional format and include a function code in it as well?

I want a spreadsheet to change the color/font of a cell/column based on a comparison of a "start date" cell and a "due date" cell. This is to automate the process of highlighting items that have gone past the due date in the second cell. I was trying to do this by looking at the "now()" function and comparing it to the due date.

View Replies!   View Related
Conditional Formatting On Due Date
Conditional Formatting for Due Dates. I have A1 which is due date and I want A1 to be formatted with red text if it is 2 days before the due date.

View Replies!   View Related
Sumproduct #Value! Error Due To Text
I'm using this sumproduct and it works until a cell has text.
=SUMPRODUCT(($C7:$C16=$C$2)*($D7:F16))

I've tried =SUMPRODUCT(--($C7:$C16=$C$2),($D7:F16)) but got the #Value! error because of the D7:F16 range. If I changed it to become F7:F16, then it works. But...my original formula adds all values giving me a YTD result. If I changed the range to be only F7:F16, then all I get is just that column's data. I have January to December's data across the columns from D to F. Any ideas on keeping my D to F range? I've tried Transpose but it didn't work either.


View Replies!   View Related
Autofilter Date Due In VBA
I am having trouble getting an autofilter to work in VBA which comes up as a 'syntax error' on this line.

Range("VehicleList").Offset(-1).AutoFilter 19,

View Replies!   View Related
Calcualting Past Due From Dates
I want to take a date (ex. May 25, 08 is in cell A2) and calculate 30 days (A2+30)June 24, 08(A6) and what i am trying to due is calculate if it is past due.

I used the if command but it does not seem to be calcualting the date plus thirty, it is only taking the date that is listed. (ex. instead of calculating =IF("A2+30"

View Replies!   View Related
Show Percentage Of Over-Due Dates
I have a spreadsheet that shows when individuals completed different events. The events are on top and the names are down the side. There are dates in the middle. I would like to know if it's possible to show a percentage of dates that are current- so take the number of fields with current dates and divide them by total number of fields. I would also like to find a percentag of events complete by each individual.

View Replies!   View Related
Reminder: Past Due Date
I want to create an Excel file, which would create alerts/reminders based on dates specified in certain cells. I want to create a database of various events (for ex. Invested in XYZ stock at $10 per share) and put a date in one of the column of each record. I want excel to remind me to take a look at that record after, say, 30 days.

View Replies!   View Related
Spreadsheet Load To Another Computer All I Get Is #VALUE
Using some custom VB code to put the filename of the document into a cell.

I save the spreadsheet and load it up on another computer and all I get is #VALUE.

How do I fix this so its loaded on every machine without problems? (Multiple people will be using these sheets)

View Replies!   View Related
How To Restrict A W/b To A Specific Computer
I've a workbook (XL 2003) test-1.xls, and I need to restrict it to a specific computer with ID: my-a1234567k

(shown under ControlPanel::System::Computer Name::Full computer name).

Is it possible to code such restriction in the w/b Open() event to prevent opening the w/b on a different computer?

My computers each has a different OS (Win 2000, Win XP Home, Win XP Prof ), different Excel version (XL 2000, 2003, 2007), etc., and the majority of my workbooks have been developed and would work only in certain environment (e.g.; in XL 2003 only, or XL 2007 only, ... ).

View Replies!   View Related
Listing Files From Your Computer
I am attempting compile a list of files from my computer into a spreadsheet but I am not sure how to get the list in the first place--I have searched many, many websites and everyone directed me here...

View Replies!   View Related
Module Runs On One Computer But Not On Another
I wrote some code that runs with no problem on my computer as well as another coworkers computer, but will not work on a 2nd coworker's computer. The "subscript out of range" error shows up at the point when the EMInput worksheet in the EMInput workbook is copied to the new workbook called "Out of Plane Section Cuts" (SEE BELOW). Is there an option in EXCEL or somewhere that could affect this. I don't see why you would get a subscript out of range error since the EMInput workbook is open....

View Replies!   View Related
Formula Works On One Computer But Not Another
I have a odd problem. I have workbook that I made I placed this formula in cell A1

View Replies!   View Related
How To Get To A Computer On Our Network Using Code
I have code below that works well most of the time. One of the cases below will not work. It insists on requiring a name and password.

(note: it is the only Windows 2000 operating systems)

I want to enter this in my case line to automatically add the username and password.

Let's say the username is: "dave" and the password is: "happy"

How can I add this to this part of the code?

Case "DJ"
strfilename = "\DAVEJONESDavesProposals" & strfilename

Sub Save_and_SaveSalesman()

Dim strPath As String, strPath2 As String, CurrPath As String

Dim WB1 As Workbook
Dim WB2 As Workbook

View Replies!   View Related
Identify A Specific Computer
I have few macros that I use to reconfigure a particular workbook into a sort of "developer mode". I keep them in a text file that I can paste them from when I'm working on it and then delete them before I send it out to other people.

I'd like to be able to script them so they only run if the workbook is open on a specific machine (namely mine). Is there any way to identify the specific computer a spreadsheet is being run on?

View Replies!   View Related
Multiple Versions - One Computer
I'm running Excel 2007 with Windows Vista. I also have Excel 97, which I was told would not run with Vista. I've since discovered that many programs that I was told wouldn't run with Vista seem to work fine.

Is it possible to install Office 97 on the same machine with Office 2007?

View Replies!   View Related
Hyperlinking Info From Another Computer
In my restaurant we have a master computer upstairs that collects all of the register sales info. Then we have a computer downstairs that my employees sign in and out on.

This excel timesheet keeps track of the amount of labor hours being used per day. Is there a way of doing this without putting the timesheet on a web page or putting my sales info on a web page?

View Replies!   View Related
Save Icons From One Computer To Another?
I want to transfer my Excel-icons. Some of them are custom buttons where I have added user-defined functions. Is there any way I can do this? A list of icons with their function or purpose is OK as well.

View Replies!   View Related
Pasting Freezing Up Computer
Here is my code. When it pastes it takes so long my comp freezes up. How do i fix? ....

View Replies!   View Related
Copyright © 2005-08 www.BigResource.com, All rights reserved